Change the source table of a form

[Guest_imported]

Newbie Question: How does one change the source code of a form? Thanks

 

[Guest_imported]

I mean the source table. Sorry.

 

[GingerR]

in form design, in the property RECORD SOURCE, choose your source

or do you mean you want diff sources at diff times for the same form?

 

[shmiller]

Do you want to change the forms record source at runtime?
If so just put this in your code
Forms("formName&quot.RecordSource = "table or query name"

 

[LaurenC]

I'm not sure how much of a "newbie" you are, so please don't take offense if this is way too basic an answer... but whenever I've been asked this question, what the person has been looking for is: In design view, at the upper left corner (about where the horizontal and vertical rulers meet), is a box. Right-click in the box, then click the properties button on the resulting popup. Select the "Data" tab in the Properties dialog, and change the Record Source to the new table (or query).