Messed up on look-up wizard

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?
 
M

M Skabialka

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Look-up Table/Column 3
Access Create option group without using wizard? 2
"Pop-up" Calendar 3
Look up field 4
Look up wizard in tables 1
Adding control after form is created using wizard 1
Look up 1
Set Value Look-up? 1

Top