Linking form to Subform

[rkhondas2000]

Good Afternoon,

Im sure this is fairly easy but have been having issues trying to link the forms. I currently have a main form, which ask for the department and date. I then created a subfolder which ask 4 detailed questions. This subform is in a datasheet view since the user can enter multiple records to the table. What i want to do is once they hit submit, for the table to get updated with the records from both the subform and form. Currently, the subform will become populate the table, but under date and department, the table is blank. Is there a way to link these two so if they select a specific dept/date, then each row they entered with information will auto populate on the table?

Thanks in advance.

 

[ranman256]

a bit confused...
theres no need for a Submit button because the subform enters data directly into the table.
If it isnt, then you did not link your subform.
In the property of the subform , data tab, :
link master fields
link child field

these are to be set to the keys in the master table.
Then you can enter data directly into the table.

 

[rkhondas2000]

Actually seem to have gotten it to work. The only problem is when I hit the refresh button or submit, the table gets updated with the correct records but it also gets updated with the department and date record with the other columns blank. Is there a way for it not to record the initial form selections as a record and just use the subform answers?

 

[rkhondas2000]

Yes you are correct. The submit button isnt necessary, but I just use it as a refresh button. That will clear all their information since they enter the information daily but in some cases, might need to enter 2-3 days of information. So in this case, they will enter the date/departmetn, answer the questions and then hit submit. Clears the information and they can enter a new date/dept.

The link master fields/child field worked like a charm. This is what is happening now.

Date	# of Positions	Type of Position	Hours Flexed	Potential Overtime-Employee Name and Shift	Department
7/28/2015	3	Register Nurses:	3	John	South
7/28/2015					South
7/30/2015					South
7/30/2015	2	Transporter	2	Michelle	South
7/30/2015	5	CLERICAL	5	Tony	South
7/30/2015					North
7/30/2015	2	EVS	5	Jacob	North

<CAPTION></CAPTION> <THEAD>
</THEAD><TBODY>
</TBODY><TFOOT></TFOOT>

 

[Micron]

Do away with the "refresh" button if these form controls are bound to an updateable query or table. If you're clearing out values when doing this "refresh" which is not a refresh at all, you are deleting them from the table too. Use form navigation buttons or (more complicated) temporary tables to handle edits and data entry.