Form behaviour for a new vs existing existing record

[Cedarguy]

Hello,



With the forum's help I was able to set up a combobox with a SELECT and Auto Expand turned on to determine the existence of a record being added.

I now realize that I need to take this a step further whereby, if the record exists then populate the field values on the form so additional subform items may be added. If it doesn't, the fields remain empty and can be populated.

The purpose of this form is to add a new Family and records (-> Enrollment -> Student) related to it further down the relationship chain; and to bring up an existing family for which additional records (further down the relationship chain) may be added.

Any guidance would be appreciated.

Regards

[RuralGuy]

Did you use the ComboBox wizard to "Locate an existing record"?

[Cedarguy]

Yes I did: is that all you needed to know?

[RuralGuy]

Does the form move to an existing record when one exists?

[Cedarguy]

No. I used the combobox to store the ID of the record of interest into the record being assembled for the "record source".

[RuralGuy]

If the form has an existing RecordSource then option #3 of the ComboBox wizard will let you move to the existing record.

[RuralGuy]

Will this method *not* work for your situation? It sounds like it would to me.

[Cedarguy]

I'll try it out; thanks for your help; I appreciate it.

[Cedarguy]

Hello again,

I tried what you suggested (i.e. Option 3 in combobox wizard) and it does work if you are after an existing record but not if you're wanting to create a new one. In my case I'd like to add and "enrolment" record either for an existing family or for a new family. Option 3 expects you to pick a value from the list.

I'm thinking of creating 2 separate forms to accomplish this and let the user pick one or the other depending upon the situation. The other method would have been more slick by making the decision automatically.
Thanks for your help.
Regards,

[RuralGuy]

Set LimitToList True and use the NotInList event to add the new record.

[Cedarguy]

Thanks; I'll try it out; I am VB challenged so not sure what code to put in NotInList event.

[RuralGuy]

How about posting what the wizard put in the ComboBox event to look for the existing record? I think it can be easily modified to do what you want.