Added a lookup column in field. How to update a form w/ change?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a new access user. I created a simple table and then created a form.
I've since gone back to my table and added lookup columns in some fields.
How to I incorporate these new characteristics into the form I created?
 
I'm a new access user. I created a simple table and then created a form.
I've since gone back to my table and added lookup columns in some fields.
Click to expand...

Take 'em back out, I'd suggest. The Lookup Field is generally frowned
upon by most Access experts - it is of *very* limited utility, and can
cause inefficiency and confusion. See

http://www.mvps.org/access/lookupfields.htm

for a critique.
How to I incorporate these new characteristics into the form I created?
Click to expand...

Regardless of whether you have the Table defined with lookup fields,
you can put Combo Boxes on the Form ("lookups" if you will). One way
is to right mouseclick the textbox that is currently on the form and
select the option "convert to combo box", and follow the prompts; or,
delete the textbox from the form and use the Combo Box tool on the
toolbar. If the "magic wand" icon on the toolbar is selected, a wizard
will guide you in setting up the combo. Again, this works even if you
haven't used the Lookup Field misfeature.

John W. Vinson[MVP]
 
The easiest way is probably to delete the controls off of the form and then
add them back in again using the Field List button. It should recognize that
the underlying field is now a lookup and format it as such. The drawback to
this is you may need to reformat the control and fix your tab order.

The other way is to right-click on the existing control and use the Change
To -> Combo Box. You then need to put in your Row Source Type and Row Source
on the Data tab of the Properties Box. The drawback here would be if you
don't set it up the same way as in your table.

Jeff
 
Back
Top