Trouble adding to new line

[kdoran]

I have a couple of tables

tblFieldTag

FieldTagID
Input
Span
Out
Description
ProblemLoop (Yes/No)
SelectDeselect (Yes/No)


tblFieldNotes

FieldNotesID (autonumber)
FieldTagID (This is a required field)
FieldNotesDate
FieldNotesText



On a form when it is opened it runs a subform (form26) that runs a query of ProblemLoops and displays the FieldTagID and a SelectDeselect checkbox (along with other info).

If I have finished the work with the Problem Loops I will then check the SelectDeselect checkbox in the subform (form26) for each FieldTagID that was finished.

On the main form are two unbound fields, DateField and TextField. I will type in the Date in one and the other I will type in something like ‘work Completed’ or whatever was done.

I will then push a button that will look for the SelectDeselect checkbox and if it is check it will autopopulate the next open line with the next FieldNotesID (autonumber), FieldTagID, FieldNotesDate, and FieldNotesText.

It will also look for the SelectDeselect Check and the ProblemLoop Check and if they are both checked it will remove the checks.

I tried using an update query but all I can seem to do is write over what was already there and not able to write to the next new line in the tblFieldNotes.

I am looking for some help or starting point on the code since I cannot figure it out the past couple of days.

Thanks in advance,

Kelly

 

[mndrlion]

My understanding is that you want to add a new record to tblFieldNotes. Use an Append query instead of an Update query.

 

[kdoran]

How do you get the info for the two unbound fields, DateField and TextField to append to the table?

On the update I had

[Forms]![searchfrmProblemLoopsUpdate]![TextField]

Thanks,

Kelly