getting started with forms

[shank]

I worked with Access forms a few years ago and seem to have forgotten what I
thought I knew. Can somone give me a kick start? I built a form using the
wizard, based on a table. I can navigate and edit just fine. However, I want
to add a drop down box to serve as a navigation tool. The drop down control
source would be a query which shows the unique [VendorID] for the table
Vendors. How do I set this up so that when a user selects a user from the
drop down, the associated record is shown in my form?

thanks

 

[Dan Artuso]

Hi,
The combo box wizard will set this up for you. Make sure your 'wand' in eth toolbox is depressed
and then add a combo, ethe wizard will click in.

 

[Dan Artuso]

Man, I have to learn how to type properly

--
HTH
Dan Artuso, Access MVP

Hi,
The combo box wizard will set this up for you. Make sure your 'wand' in eth toolbox is depressed
and then add a combo, ethe wizard will click in.

--
HTH
Dan Artuso, Access MVP

I worked with Access forms a few years ago and seem to have forgotten what I
thought I knew. Can somone give me a kick start? I built a form using the
wizard, based on a table. I can navigate and edit just fine. However, I want
to add a drop down box to serve as a navigation tool. The drop down control
source would be a query which shows the unique [VendorID] for the table
Vendors. How do I set this up so that when a user selects a user from the
drop down, the associated record is shown in my form?

thanks

 

[shank]

You gave enuff info for me 2 do what eye needed!!!
)

Man, I have to learn how to type properly

--
HTH
Dan Artuso, Access MVP

Hi,
The combo box wizard will set this up for you. Make sure your 'wand' in
eth toolbox is depressed
and then add a combo, ethe wizard will click in.

--
HTH
Dan Artuso, Access MVP

I worked with Access forms a few years ago and seem to have forgotten
what I
thought I knew. Can somone give me a kick start? I built a form using
the
wizard, based on a table. I can navigate and edit just fine. However, I
want
to add a drop down box to serve as a navigation tool. The drop down
control
source would be a query which shows the unique [VendorID] for the table
Vendors. How do I set this up so that when a user selects a user from
the
drop down, the associated record is shown in my form?

thanks