Two forms: one for editing, one for new records?

[Leonidsg]

Hey all,

So I have a question about creating forms with two purposes in mind. I would like a form to create new records, it seems the easiest way is to set the DataEntry to "Yes" that was when people open a form they wont accidentally edit an existing record. However I would like the same form to be searchable so records can be edited. I think it may be best to have two forums, one for editing records and another one for new records. Is this poor design or is there a better way? Also I was wondering in the editing form I want my Medical Record Number field "MRN" to be searchable, that way I can type in the MRN and the fields are populated for editing and adding additional data if gathered. I was going to use "Event" "AfterUpdate" property for the field, is this the best way?

Thank you for the help.

Lenny

[pbaldy]

I typically use one form. You can control which way it opens with the arguments of OpenForm. Try the combo box wizard for searching, the third option "Find a record".

[Leonidsg]

Can you please explain where I can find the arguments of OpenForm, is that the same a Porperty sheet, "Data". What settings would you recommend. Ideally I would like to form to load blank ready for data entry, but still be able to search using the combobox to check if a record exists.

Thank you
Lenny

[pbaldy]

You can find a pretty good description about all the available arguments in help.

[Leonidsg]

I geuss my question is if Macro OpenForm is the same as making a "Control Button" with the action "OpenForm". Thank you again for all your help.

Lenny

[pbaldy]

I personally use VBA, but the macro version would have the same arguments available, so you should be able to use either.