J
Jeff Boyce
Melissa
Why use two forms to do what one form can handle?
One form, with an unbound combobox in the header. The combobox lists all
available advertisers.
The form is based on a query that uses the selected advertiser in the form's
combobox as a selection criterion (I usually use the rowID field).
The combobox's AfterUpdate event tells the form to requery (something like:
Me.Requery).
When you first open the form, the query looks to the (empty) combobox and
loads that record (i.e., none). When you pick an advertiser in the
combobox, the form requeries and loads the info re: that advertiser.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
Why use two forms to do what one form can handle?
One form, with an unbound combobox in the header. The combobox lists all
available advertisers.
The form is based on a query that uses the selected advertiser in the form's
combobox as a selection criterion (I usually use the rowID field).
The combobox's AfterUpdate event tells the form to requery (something like:
Me.Requery).
When you first open the form, the query looks to the (empty) combobox and
loads that record (i.e., none). When you pick an advertiser in the
combobox, the form requeries and loads the info re: that advertiser.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP