07 Form behavior

[NetworkTrade]

Created a simple continuous form in Access07. Used basic form design;
assigned the record source as a query and then used the field list to drag
fields onto the form.

The record source query runs fine. But the form throws parameter prompts
when it opens. I click thru them with OK and then it opens fine.

But I can't figure out why it is throwing parameter prompts for fields that
are not part of the query, are not in the field list, and are not on the
form. They are fields that are on the table that the query is sourced on -
but not needed/used in the query...

It is the type of prompt that would make me think that the form's query is
based on another query and that the originating query data is missing - but
in this case it is the table itself....so I see no way to correct or work
around this....

Kind of tending to think this is an 07 issue
Thoughts?? tia

 

[boblarson]

Don't know if this is your problem but I've found that problem before with
LOOKUPS that are at table level.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[NetworkTrade]

thanks for taking the time to reply....

am not sure what is meant by 'lookups at the table level' - would be
interested to understand what you mean....not sure what a 'lookup' is vs a
query and then in my mind querying a table is the most common thing in the
world....so your refinement of my understanding is most welcomed...

my query was serving only the purpose of reducing the quantity of
columns/fields and doing a sort. I can live without the sort, and can reduce
the columns/fields by simply leaving them off the form...so I re-sourced the
form directly onto the table and got rid of the query and it works fine...I
did not modify the form at all.

but really there is something odd; definitely this is not pre07
behavior...and for the form to generate a parameter prompt when its record
source query does not - is really strange...

 

[boblarson]

No, lookups at table level look like this:

http://downloads.btabdevelopment.com/screenshots/lookups/tablelookups.png

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[NetworkTrade]

oh sure - understand that....a lookup field....

well now that is interesting because without yet having relooked at this
database I can see now your point...a lookup field is in essence another
query one level down...

there are nulls in some fields and I can imagine that this could
theoretically be the cause yet still

at the same time it is not pre07 behavior..... will double check
it...thanks - - even if I don't change anything further I always do like
clarifying things to myself.....