getting started with forms

S

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
 
D

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.
 
D

Dan Artuso

Man, I have to learn how to type properly :)

--
HTH
Dan Artuso, Access MVP


Dan Artuso said:
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


shank said:
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
Click to expand...
Click to expand...
 
S

shank

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


Dan Artuso said:
Man, I have to learn how to type properly :)

--
HTH
Dan Artuso, Access MVP


Dan Artuso said:
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


shank said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top