Selecting a record from a combobox


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
 
Ad

Advertisements

M

Melissa

Hi there

I have a form for "Advertisers" which is a form that includes contact info
for my advertisers.

i have created a seperate form, and on this form, i want to insert a combo
box where i can select
an advertiser from, and then when i select the advertiser in the combo box,
i want my "advertisers" form to open, showing that specific advertiser i
selected

please help

thank u
Melissa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top