Parent Form data entry mode not working

[wmix]

Hello Everyone,
I have a data entry from I'm trying to create based on a query that is misbehaving. I'm hoping somebody can point me towards a solution / reading so I can figure out a solution.

Then I have a query I turned into my parent form (frmCollections). This query is based on a large table with information about when a vending machine gets filled and money is collected. When the query opens the user has to input the truck # and a route week/day. With the information the query pulls up all the machines the driver goes to that day. The query works perfectly. So I turned this into my parent form. When I step through the form I see each machine being filled that day.

Here's the information in the query and on the form:

frmCollections
MachineID
MachineName (for viewing purposes only really)
TruckNumber
RouteWeek/Day
RouteOrder (used for sorting purposes)


Next, I created another form (frmCollectionsSub) and this form has it's own subform (frmCollectionDetailsSub). These forms are associated with tables to store the actual money being collected for each vending machine.

frmCollectionsSub
MachineID
CollectionID
Date
CollectionNotes

frmCollectionDetailsSub
CollectionDetailID
CollectionID
$20 bills, $10 bills, etc...

Here's the issue. I cannot make the parent form a data-entry form, if I do then I cannot see the vending machine information. However, if I take it out of data entry mode then I see all the old information.

Idea's on how to "fix" this problem? Thank you in advance.

[NeoPa]

Data Entry is a mode that doesn't show existing data in the table. It isn't the only mode that allows data entry by any means. It means exclusively data entry.

Does that help?

[wmix]

Thanks NeoPa. Okay, so my subform and sub-subform are both data entry - but it appears it's the main form that's causing me issues. If I have it in data-entry mode then when I run my query at the very beginning it does not show me the information I need. I may need to rethink how I'm going to enter all this data.

[NeoPa]

It may prove helpful for you to describe a little more clearly what data you wish to see and what you don't.