Subform Help

[alyon]

In access 2007, I have a form with combo boxes Name, Address, and Contact Info. They are cascading combo boxes to make it easier on the people filling out the name, since the same information is often used again.

However, when there is new information, they want it set up (they suggested a subform) so you click a command button to open it, and on the subform lists: name, street address, city, state, zipcode, work phone, home phone, fax, email.



I somehow have to get the Street address, city, state, zipcode to combine together in the Address box on the main form. and Work phone, home phone, fax, and email to combine together in the Contact Info box on the main form. Is this even possible? Please Help.

[NTC]

Yes it is very possible. Let's say you have the subform set up - then we assume data put into it does write to the underlying table.

This means that if you close your main form (and subform) - and then reopen the main form - that you will now see the info in those combo boxes.

This is key - because you have to close & reopen that form. The reason is that the data that goes into those comboboxes is correct the moment you open the form. If you then add more data via the subform, the comboboxes haven't had a chance to be updated.

The more elegant method is to force those comboboxes to requery. This is a standard VBA method that you can use - and trigger it perhaps in the closing of the subform.

Hope this helps.