linking a form to a query

[sha7jpm]

I have a form which runs a query. there are many records shown in the query.

the query displays all the data correctly.

but I need to reference this to text boxes within a new form.

so...

line 1 of the query has the details for a particular record, the text boxes need to link to this.
same with line 2 etc.

is there a way of referencing the syntax to only look at line 2 of the query results for example?

 

[Hayley Baxter]

This isn't displayed on a new form but I thought it might help you a little.

 

[sha7jpm]

thanks...

cheers for the attachment.

what I am really looking for is this...
I already have an exisiting form which links to syntax for an email.

I need to populate the form with data from a query.

each line of the query is a different record.

so I have up to 25 lines in the query.

my form has 25 lines of text boxes, one for each field in the line.

I just cant seem to link the textbox to the query and specifically to a particular line in the query.

so for example the 1st text box on line 5 would link to the first field in the query on the 5th line.

very frustrating!!

 

[Hayley Baxter]

John

If I get a little time tomorrow I'll see If I can update that sample to better suit your requirements.

Hay

 

[sha7jpm]

have sorted the problem.

hayley,

many thanks for your offer, think I have sorted the problem by running a form off each line of the query and then linking the final form to each individual form.

a bit clanky and slow but it does work.

many thanks.

john

 

[sha7jpm]

apologies,

can you explain what that exactly means and entails?

many thanks

J