Form Defaulting to Row 1

[abbaddon223]

I have a data capture script which means Im segmenting forms.

When I input the data in form 1 and navigate to form 2, all the fields in form to are looking at record 1 in the table. How do I get this to keep pointing at the row I've created from form 1?

I'm getting closer with putting a text box in there with (example)

=[Forms]![Form1]![SchoolName]

This is pulling through the school name from form 1 (great) - but as I say, all the other fields a relating back to row 1 rather than looking at row 2

Help greatly appreciated...

 

[vbaInet]

Are those fields properly bound?

What do you mean by data capture script?

 

[abbaddon223]

Hi,

Thanks for the response

There's nothing bound (if you're referring to subforms) - the only field that is referring elsewhere is the text box (afor mentioned).

If I drop a subform in, the subform links to the master fine, however its not the direction I'm steering in.

By data capture script, I just meant that I'm closing one form, and needing to open another (on the same row) so that I can progress from screen to screen (form to form).

I know one answer is to have all the questions on one form, however it would be vast...

 

[vbaInet]

Here are some links that will help you solve your problem:
http://baldyweb.com/wherecondition.htm
http://baldyweb.com/OpenArgs.htm
http://baldyweb.com/Bookmark.htm

Welcome to AWF by the way

 

[abbaddon223]

Thanks for the help - I'll take a look through these - have a good one and thanks again!!

 

[vbaInet]

You're welcome. Good luck with your db.