Move record to current one in sub form

[Ade F]

This is a very simple one people but my brain has been fried over the las few hours. Please excuse the messy layout its just for working.

See below

Basically when moving into form one how would I move te record in form two to the current Orderdetails_counter? At the moment the record pointer stay on (80) the previous entry?

I'm doing some error checking / double booking etc and so sub form2 record has to correspond with sub form 1 (Orderdetails_counter).

All the best

Ade

 

[jgc31]

Ade

Couple of threads that I contributed to on similar subject

http://www.access-programmers.co.uk/forums/showthread.php?t=78400

http://www.access-programmers.co.uk/forums/showthread.php?t=77869

not sure if they are directly relavent but they might help

 

[Ade F]

a little more

I wondered if you could think of a way of setting focus to the corresponding orderdetails_counter in this case 81 sub 1 to 81 sub b this way if someone where to add say 1 and then go away into another sub and then come back to the original entry adding subsequent numbers would be caught.

Cheers

Ade

 

[Ade F]

Its OK now

After several cups of tea I have now awoken and fixed the relationship for query in sub form 2. Now it only show the relative Orderdetails number.

Sorry for the hassle.

Regards

Ade