open form find specific data

[Milothicus]

I need to create a button on one form to open another form to the same record. i've tried using the wizard, and everything looks like it should work, but it doesn't. the form still opens with a blank recordset. the field i'm using to link the two is the autonumber index of my main table (which queries for both forms include).

i tried the other method too: open the new form, open the recordset, findfirst, etc. but it can't find the value in the recordset.

when i look at the output of the query the target form, some records come up twice because of a one-to-many relationship. for my purposes, that's fine, but is that what's screwing up the find function?

i'd think it's something to do with my programming skills, but the wizard's button didn't work either.

anyone else seen this before?

i'm working in access 2000, at the moment, if that helps.

 

[Milothicus]

Well, after stepping through the code many times, i discovered that for some reason when the new form was opened, the query wasn't run. the recordset's field count was correct, but record count was 0.

a requery after opening solved the problem, but i shouldn't need that. what's going on here?