Form with Linked PopUp Form

[aceoftrades]

I have a form frmClient that is a tabbed form. Client Info / Project (frmProject_subform) / Calls (frmCalls_subform) ... in the tabbed Project section I need to be able to add Employee Hours, Contractor Hours and Products. There is not enough room to do this through a subform so I was hoping to do it through buttons (ie. Employee Hours button opens popup form frmProject_Employee_Hours (tblProject_Employee_Hours) which is linked to the current project form and different employees hours can be added.) Same with Sub Contractors and Products This is proving harder than expected...any suggestions are appreciated

[rpeare]

Can you be more clear about what 'this is proving harder than expected... ' means

[aceoftrades]

Sorry...it doesn't work as far as I can tell since there isn't a Master/Child Link between the frmProject_subform and frmProject_Employee_Hours. If I put the frmProject_Employee_Hours on the frmProject_subform as a subform it works because they are linked but as I said I won't have the room on the form to put these subforms.

[rpeare]

so you are having trouble creating a link between the two tables involved.

The way I have handled this (one of them anyway) is that when you want to enter information on this secondary form when you open it have a combo box on that form that is unbound. Have that combo box's primary key be the employee_ID and force the selection of that combo box to be whatever is currently displayed on the 'main' form. (basically set the locked value to true). Use that as a criteria to look up the employee on this secondary form and bind the data source to the employee table. Then create a subform to enter the data you want. If you've correctly locked the form all data entry on this secondary form/subform will be applied to the employee on the main form.

[aceoftrades]

I'm really not following...Can you be a little more detailed as I'm new to Access... I currently have the secondary form frmProject_Employee_Hours which has WeekEnding_Date (text box) Employee_Hours (text box) and Employee_ID (combo box) Employee_ID is a query which displays the current employees in the combo box but puts the employee id in the Employee_ID field of the table. It works perfect when is placed as a subform on the form frmProject_subform which is the form on the page Projects. When don't have it as a subform but rather a separate form which is opened by a button within the form frmProject_subform (ie Enter Hours) I get the error message "You can not add or change a record because a related record is required in the table tblProject. " I'm assuming because it is not linked.

[rpeare]

can you upload a sample of your database, I'd rather not have to recreate an example from scratch.

[aceoftrades]

how would I do that?

[rpeare]

make a copy of your database, take out any information you feel is sensitive but put in enough data to help solve the problem, compact/repair the database, zip it up and upload it through the GO ADVANCED option.