By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,222 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,222 IT Pros & Developers. It's quick & easy.

ALL records in combo box

P: 1
Please help....been at this for several days and just can't seem to find a solution. I've got two tables, Emp Info and Labor Records. The form to populate the Labor Records table contains a combo box for Emp Number (from Emp Info), a txt field for shift date and other fields. I need the ability to add a record "for each" Emp Number with the same shift date to the Labor Records table when there is no labor record information available (a mainframe problem). Currently there are aprox 100+ emp numbers. My goal is to avoid entering this information 100+ times. I've tried just about everything I can find concerning "ALL" records from a combo or list box but have been unsuccessful to date. Is this do-able? Is there another way to do this?Any help would be most appreciated. Not only am I responsible for building this DB but I will also be responsible for the data input.

A side note: I am very, very new at this ACCESS and VBA thing. Please don't feel that there is such a thing as 'too much' information. I need a detailed map here please if there is a solution to my problem.

Thank!
AW
Aug 10 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,392
What about running a query?
Aug 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.