Hi All
I have a combo box (Full Names) on a form that is unbound but is associated with the address fields. Every time the form is open the address fields show the first record details but the combo box is blank.Is there any way to have the address fields blank until the combo box is selected

Brendan Bartley

__________________
Brendan Bartley

Use an unbound form.
I am assuming that "I have a combo box (Full Names) on a form that is unbound..." means the combo box is unbound.

mmcdonal

mmcdonal,

In what cases should you use an unbound form besides a search form?

mmcdonal

If the form is unbound and you use unbound fields how do you associate the fields to the table
Thanks

Brendan Bartley

There is more programming involved. But typically in the case you have here, you leave a default selection, which is usually the first record in the table. If you want to remove that, then you use an unboind form and program all of the functions. It is simpler to leave the first selection, and then tie the combo box to the record selection on the form's On Current event using:

cboComboName = PKFieldNameID

HTH

mmcdonal

Is "On Current" the event that occurs when the form shows a new record, like when I click the next record navigator control?

Yes. The Form's On Current event fires when the record changes to a new record.

mmcdonal

Thanks, mmcdonal. Do you know of a source of information about events?

Coincidentally, WROX has a book called Access 2003 VBA, soon to be updated with 2007, that discusses all sorts of events.

Most Access books cover Events and when they happen.

I am sure MSDN also has a lot of information about what events are on what objects, and when they fire.

mmcdonal

mmcdonal
I have left the form unbound if the table name is tblsuboffices and the field name is group how do I tie the table and field into the form when the combo box is selected
Thanks

Brendan Bartley