By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Parent Form data entry mode not working

P: 5
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.
Aug 11 '17 #1

✓ answered by 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?

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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?
Aug 11 '17 #2

P: 5
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.
Aug 14 '17 #3

NeoPa
Expert Mod 15k+
P: 31,186
It may prove helpful for you to describe a little more clearly what data you wish to see and what you don't.
Aug 15 '17 #4

Post your reply

Sign in to post your reply or Sign up for a free account.