RecordSource in VBA (Again)

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

Please clarify for me (again) Access 2003 SP3 XP
If I open a new form with no controls on it and create the
RecordSource in code such as
Me.Recordsource="Select * FROM tblMyTable" ...... Should I expect a
field list to appear in order to now populate my form or do I have to
assign the ControlSource in code as well?

Thank you
 
If you assign the RecordSource at runtime, you will have to assign the
ControlSource of your controls as well.

Be careful: you can crash Access (shut down by Windows) if a field
disappears or changes data type.
 
If you assign the RecordSource at runtime, you will have to assign the
ControlSource of your controls as well.

Be careful: you can crash Access (shut down by Windows) if a field
disappears or changes data type.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.







- Show quoted text -
Click to expand...

Thank you Allen. The warnings will be heeded and I will put the SQL
where it obviously belongs. In this case there is no need for it at
runtime and "Now I know"

Thanks again
 
Back
Top