D lookup (1 Viewer)

[NickNeville]

Good morning
Could you help with a piece of code please.
I have a Subform on a form which holds names of club members, the subform which is derived from a query has a "Next record" button which brings up the records as I click.
my question is can I make the record on the main form change as i click the button by Dlookup or something like this.
your help most appreciated
Rgds
Nick

 

[Galaxiom]

It sounds like you have the form and subform the wrong way around.
The other way the subfrom can track the main forms current record using the Master/Child Link Fields properties of the subform control.

 

[NickNeville]

many thanks your quicko reply
Do you mean make the main form from the query and the sub form from the what is currently the Main form ?

Rgds
nick

 

[NickNeville]

Yes that works a treat
many many thanks

N