Datasheet subform not moving to next entry

[Stephanie T.]

I have a main form that tracks returns from our Distributors. I have a subform on that main form that is powered by a query and linked to it’s own table for storing that info. The subform tracks three pieces of information: the product purchased, the amount of credit requested, and the reason. The subform is set up in datasheet style so that information can sit like a list on the form.

The problem that is occurring is that when I enter the product name (which is a combo box powered by a query from the Products table), then the amount, then the reason for return (also a combo box powered by a query linked to a table that only holds that information), the subform doesn’t progress to the next line, instead it pops the cursor back to the first line.

The main form is opened by a command button on another form and there is some information, such as our internal tracking number, that is automatically entered into the main form. Could that have something to do with the subform only wanting one entry? Does anyone know how to fix this?

Thank you,
Stephanie

 

[Jeff Bailey]

Look at the Cycle property for the subform. It needs to be set to all records.

Jeff

 

[Stephanie T.]

Thanks for the input. It was set to all records, so obviously that wasn't the problem. I decided to re-created the form and subform. When I did this I also went through the relationships and made sure they were all properly set up. I'm not really sure what fixed it, but now it is working great. I suspect the problem was in my relationships all along.

Thank you,
Stephanie