One form for filtered records and Data Entry?

Is it possible to have one form that displays a specific record when you click one button and then use the same form as a data entry form if you click a different button?

The form wouldn't be open twice simultaneously, but I am trying to not have to duplicate the form for these two operations and then need to update them both if I change anything????

(For the specific record button i just use the button "wizard" in Access that writes the code to filter the records)

Currently for the data entry form it's identical to the other except the data entry property is set to 'yes'

Is it possible to write a small bit of code that sets this property if you click the button for a new record???

Since you are still using wizards... ;) yeah its probably possible. Have a look at the form properties...

Code under the button would probably be something like:

VB Code:

Me.AllowEdits = not me.allowedits 'True

Set to true to allow editting, and false to be read only... You could use a toggle button, which would be in and out with the above code ;)


Vince

Wizards are useful for writing the code behind buttons for operations you can't be bothered to write it for...or simply don't know it! :bigyello:

That info helped, thanks!