Append query to current record only (1 Viewer)

[SarinaStow]

This is my first time posting to a forum so don't hesitate to correct me if I am doing something wrong.

I am trying to create autofill templates based on the worktype.

How do I append data to the current record only!

I have a table that contains all of the job information including a record autonumber.

I have made a form using this table and it includes a subform for charge items from a separate table.

My users are complaining about having to key in every line item and want the form to autofill the subform for charge items based on the worktype field.

I have written an append query which is correctly extracting the worktype field and updating the charge items fields but it is doing so for every record with the same work type. I just want it to update the current record I am looking at.

 

[cassi84]

Try using the unique identifier for that specific record for the query.

You can use
[Forms]![form name]![field name]

where the form name is the name of the form and the field name is the unique identifier.

Let me know if this solves your problem.

 

[SarinaStow]

It worked like a charm. Thank you so much!

 

[Megan]

Try using the unique identifier for that specific record for the query.

You can use
[Forms]![form name]![field name]

where the form name is the name of the form and the field name is the unique identifier.

Let me know if this solves your problem.

This worked for me too, thank you! Funny how it is so easy to overlook the simple things.