N
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
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