syntax for selecting a record from a subform based on a query

I

Italian Pete

Hi,
I want to select a record from a subform (sbfrmKitOut) and on clicking a
"Return Kit" button, run an update query qupKitReturn using the vallue of the
Loan ID (Loan_id) which is the first fiemd in the subform. The subform is
populated from a query: qryKitOut. What is the syntax for selecting this
record? I've tried to use:

Forms!frmMain!sbfrmKitOut!Loan_id

but this doesn't seem to work.

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
VBA code returns no records hwenKey ID is added 14
Subform Issues 1
Basing a subform on a selection from either of two subforms 3
Passing a value from subform or main form to subform query 4
How to program Subform as select list 2
go to specific record based on choice in subform 2
insert sql form-subform problem 0

Top