Messed up on look-up wizard

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I'm trying to make a database that will enable me to track people going on
travel. When I set up the form, I was focusing on creating the calendars
(for dates leaving/returning). Once I figured that out, I realized that I
had wanted to have the "Name" field use a separate table that has a list of
names already in it. I know that I should have designed the table field to
be a look-up wizard, but I neglected to do that. Is there a way to do it
from Form Design, so I don't have to re-code all the calendars as well?
 
Personally I hate look-up fields in tables.
Try adding a combo on the form for that field, looking at the other table as
the source. Use the name of the field as the combo name and Control Source,
but use the combo wizard to create the Row Source.
Mich
 
Back
Top