Can I have more than one record source on my form in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form based on a query that is not allowing me to add more
fields to it because it is based on 10 different tables with more than 250
fileds. Is there anyway to add more than one query to a form?
 
ctate said:
I have created a form based on a query that is not allowing me to add more
fields to it because it is based on 10 different tables with more than 250
fileds. Is there anyway to add more than one query to a form?
Click to expand...

A form based on 250 fields in 10 different tables smacks of very poor
design. I would seriously consider having the design analysed with a view
to normalising the data.

Having said that you can use code in the form's On Open event to set its
data source:

If <some condition is true> then
Me.RecordSource = "qryQuery1"
Else
Me.RecordSource = "qryQuery2"
End If

Regards,
Keith.
www.keithwilby.com
 
Back
Top