Form Based off query

B

BMBerna

I have a query which I need to put into a form. I continue to get
#Name? in every control source. I am not sure what i am doing wrong.
My form is based off a table and a query. I have never had trouble
like this before. Not sure what I am doign wrong. Any suggestions?
 
F

Fred

Having the form based (directly) off of both a table and a query sounds like
confusion or a problem.

You want to make sure that you have a clear understanding of what you
want/need to have as a data source. (For a basic form, and someone who is
relatively new to this, this sould be one table or one query. (the query
could be a join of 2 tables).

Then either make sure that your form has that data source or (re)create a
new form with that data source. ("record source")

- - - -

If you want to work backwards to troubleshoot your existing form, look in
it's properties and see what it's "Record Source" is. This will be a query
or a table. Open up that record source directly. Chances are you will not
be able to do this and will have found your problem.
 
Top