Form creation

[mrrherrera]

I want to create a form where the user selects a specific case number and a
form pops up or opens where the user can fill in the blanks. The form needed
for inputting the information has already been created. If the
information/case already exists, the user will then be shown all the records
already entered for that specific number. If it doesn't exist, then the
blank form opens up. How do I create this?

 

[mrrherrera]

Thanks, I'll try it.

Make a form with a combobox that has the field with the case# as the
rowsource. Make sure it is not limit to list.

In the combobox properties, select the AfterUpdate event and put a macro or
code to open the form you mentioned. Set the form's filter to the first
form's combobox.

Bonnie
http://www.dataplus-svc.com