Four input tables one output

[aonsu209]

Dear all,
I'm having troubles to create single form with following input in the graph below:


The form looks like this pic



The problem is it is not working Any suggestions how can I make this to work? Where I making mistake?

[ranman256]

A combo to pick the employee
A combo to pick the project
A combo to pick the part (once project is picked)
box to put in time.

SAVE button.
on click, run append query to put data in final table.

[aonsu209]

A combo to pick the employee
A combo to pick the project
A combo to pick the part (once project is picked)
box to put in time.

SAVE button.
on click, run append query to put data in final table.

Like that sounds easy, but I forgot to write that there are some restriction. I want the form to open on specific employee and the employee to fill some of the general input, and some to be there. For example the week to be combobox and the period to appear after update(Dlookup).


Any other suggestions? I try something like in this video, subform based on many to many relationship, but it didn't work.
http://www.youtube.com/watch?v=Ou1zwJunbuA

[June7]

What does 'not working' mean?

Why use UPDATE query for data entry?

If data structure is properly designed and form/subform/subsubform properly configured, data entry should be simple. However, the image looks like a type of time and attendance database, one of the most difficult to design IMO.

Opening a form filtered to an employee and pre-filling fields is easy. But how do you want to determine the employee ID parameter? Select from a combobox on a 'navigation' or 'switchboard' form then open the data form?

DoCmd.OpenForm "data form name", , , "EmpID = " & Me.comboboxname

[aonsu209]

Yes, I will create for each employee a separate form. And thanks for the idea I will do it with append query. When some check "Released" to do up append query. Here is the new flow diagram:


And now I`m having another problem how to requery combobox in sub subform from the after update in the subform?

[June7]

Create a form for each employee???? Why not one form and filter it?

[aonsu209]

Create a form for each employee???? Why not one form and filter it?

Previous one was in excel and there are shortcuts for each employee's and I want to keep it same. Actually my first idea was one multiple form and on click on the name to popup form with the employee. Any ideas how to requery in sub subform after update in the subform? I try few things like:
Public Sub RequeryList()

Dim Combo18 As Control

' Return Control object pointing to a combo box.
Set Combo18 = Forms!Time(SubForm)!Forms!ProjectParts(subsubform) !ReportsTo

' Requery source of data for list box.
Combo18.Requery

End Sub

[June7]

Don't need the control object variable.

Where is this code placed?

[aonsu209]

Don't need the control object variable.

Where is this code placed?

I placed in the main form. I think I solved it, I set a macro on the combobox itself on change to refresh and seems it is working.
Thanks for the help.

[June7]

I would use AfterUpdate and/or GotFocus events instead of Change event.