Query Fields

[chris11590]

I made a form which is from a select query. the query has numerous table and therefore numerous fields. the form appears empty in form view. all the fields are there in design view. i looked at obj source. its is off the query.

what could be causing this problem?

 

[redneckgeek]

Not sure I really understand your question

Does the query itself return any records?

 

[MSAccessRookie]

I made a form which is from a select query. the query has numerous table and therefore numerous fields. the form appears empty in form view. all the fields are there in design view. i looked at obj source. its is off the query.

what could be causing this problem?

Are you referring to the record source(for the form), or are you referring to the Control Source (for each control)? Rednegeek poses a very good question. Does the query produce results in a standalone datasheet?

 

[chris11590]

not quite sure how to pose the question because not sure what the problem is. my form is just all grey, blank , no fields. when i use the wizard to create the form, i select the select query to base it on. so i am assuming that is the problem.

chrissy. thanks guys for the help

 

[MSAccessRookie]

not quite sure how to pose the question because not sure what the problem is. my form is just all grey, blank , no fields. when i use the wizard to create the form, i select the select query to base it on. so i am assuming that is the problem.

chrissy. thanks guys for the help

Perhaps it is the query causing the problem instead of the form, because it sounds like you might not have any data to display. Run the query by itself and see if it produces any results.

 

[khawar]

I think as you have a lot of tables in the query so it has become read only

Do as below

as suggested open the query in datasheet view check if it displays records

If it doesnot display any record
but displays a blank line for the new record as you see at the end of table
then the query is not read only and problem is some where else most probably in your form

other wise if it does not displays line for new record then the reason is that the query is read only and you dont have any record to display on the form and on the other hand you cannot add new record as the query is read only so the form goes blank

 

[chris11590]

i dont have any records in the table so it will not display on the query, but i figured at the least i would see a blank line for enter.

 

[khawar]

Then check the properties of your form
AllowAdditions should be set to yes
and
dataEntry should be NO