Query issues after 1st record

[steve1111]

Hello,

i have a form that has a cbx that controls two queries, a van profile and a reallocation query. I have buttons that switch each query visible.true/false depending on what i need to see. when i go to the allocation query (which defaults form view) the query pulls in some basic van info from another table and then i can add the reallocation details to a new location.

my issue is this, if i have say 214 that does not have a record in the tblReallocation table, the query loads nice and once i start adding info assigns a reallocationID and saves nice to the table. but then if i open the reallocation query form again, it brings in 214's last record, and if i do a GoToRecord on open then none of the relationship data loads, all fields are blank.

How can i get my criteria to load but the query still go to a new blank ID entry?

i cannot upload the DB but i have attached a picture to help visualize.

thank you

 

[steve1111]

Yes the data entry mode is ok, I can enter a record if a reallocated record has never been entered for the specific van, i just cannot get it to give me an option for a new entry with the relationship fields entered in the new record.

I think it may have to do with using 2 PK in the query? Getting a control cant be edited bound to an autonumber field...

for now i have rearranged the query to use the like foreign key and switched the form to continuous. Not ideal, but i can enter multiple reallocation that way.