getting started with forms

  • Thread starter Thread starter shank
  • Start date Start date
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
 
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.
 
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...
 
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...
 
Back
Top