Prev: Invalid use of Null error question
Next: Using VBA to select Items in multiselect Listbox
From: TeeSee on 21 Dec 2009 08:14
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
From: Allen Browne on 21 Dec 2009 10:50
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.


"TeeSee" <bkeanie(a)glasscellisofab.com> wrote in message
news:e2afe00a-65b9-486c-9697-3a6ee78b995d(a)m3g2000yqf.googlegroups.com...
> 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

From: TeeSee on 21 Dec 2009 11:38
On Dec 21, 10:50 am, "Allen Browne" <AllenBro...(a)SeeSig.Invalid>
wrote:
> 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.
>
> "TeeSee" <bkea...(a)glasscellisofab.com> wrote in message
>
> news:e2afe00a-65b9-486c-9697-3a6ee78b995d(a)m3g2000yqf.googlegroups.com...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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
 | 
Pages: 1
Prev: Invalid use of Null error question
Next: Using VBA to select Items in multiselect Listbox