Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple question?

Status
Not open for further replies.

Aerowolf

Programmer
Nov 6, 2002
64
I've got 2 tables; Employees and Timesheets

On a form I want to display a list of the employees on the left of the screen and the timesheet entries on the right. When the user selects the employee, the correct entries show on the right. I want to be able to add to the timesheet entries.

I can make it work if I use a normal text box for the employee and page up and down through it, but when I try to change the text box to a List box and specify the source as the Employees table, I get an error (duplicate error) after I select the employee and tab out of that field to go into the timesheets side.

Help!
 
I would make the Employee bit a subform. On the main form, put a text box that has a control source of

=[EmployeeSub]![EmpID]

(=SubFormName!FieldNameInTheSubform)

Name that text box txtChosenEmpID.


then for the Time Card Master/Child Links,

Child = EmpID (or whatever you call it)
Master = txtChosenEmpID

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top