query1 popup on form - Microsoft Access Forum


	Back to Access Forum Comments List

query1 popup on form

Katherine Bradshaw

4 years ago

For once, I've got just a simple query with only a single criterion - dates within the past year.

But when I try to open the form I made from the query, it pops up a window asking for query1.PaymentDate. If I don't type anything but click OK, it shows what appears to be all the correct data, just not sorted.

I was lazy and copied the form design from another form - maybe I have some kind of property turned on that I don't want? I've been looking around and can't find what might be the trouble.

	Katherine Bradshaw OP @Reply 4 years ago

	Katherine Bradshaw OP @Reply 4 years ago

	Katherine Bradshaw OP @Reply 4 years ago
Oh - hm. Maybe it's because the table has a default of =Date(). I have a subform I use for data entry for membership payments. Maybe I should put the default date in the form, instead of in the table? What consequences might that have for my existing data or other processes? Hm . . .

	Kevin Robertson @Reply 4 years ago
Do any of your other columns in your query refer to Query1?

	Richard Rost @Reply 4 years ago
First, you don't need to CDate a date field. It's already a date. Even after subtracting a value from it. Second, don't name your query "Query1". That's just asking for trouble. LOL. The table default of =Date() wouldn't cause that popup. Double-check the Record Source property of the form and make SURE you have it set to Query1. Something is looking for it, and it's obviously not loaded.

	Katherine Bradshaw OP @Reply 4 years ago
Well, there is no "query 1", so I'm not sure where that's coming from. The MemberPaymentPastYearQ is just pulling direct from tables.

	Richard Rost @Reply 4 years ago
I would bet you are correct: "I was lazy and copied the form design from another form - maybe I have some kind of property turned on that I don't want? I've been looking around and can't find what might be the trouble."

	Richard Rost @Reply 4 years ago
Some object is bound to or looking for Query1. Find that object. Form, subform, field, etc.

	Katherine Bradshaw OP @Reply 4 years ago
I had Cdated a previous criterion like that because the regular date didn't work - probably because it was one of my complicated queries that made Access forget it was a date. LOL Oh! In the form properties it IS trying to find a Query1 in the "order by". Weird. Maybe an artifact from copying the form?

	Katherine Bradshaw OP @Reply 4 years ago
Thanks, Kevin and Richard! I deleted the "order by" in the properties, and it works just like I want it to now.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen