How can i add a control source to an Access form

[Guest]

I've created all the forms i intend to use for my database using only the
design view but double clicking on 'Create form in Design view'. But now
i've realised that none of my forms have any tables associated with them
which makes them completely useless!

How can i associate tables with my forms like i could have done if i had
used a wizard?

Thanks in advance

Blue

Access 2003

 

[Nick Coe \(UK\)]

Open your form(s) in design view then open the property
sheet for the form (View|Properties from the menu bar).

Click either the Data tab or the All tab on the property
sheet. At the very top you should see Record Source, that
is where you set the table or query from which the form gets
its' data.

Given that you've done this the hard way <g> I wonder if
you've got your control names right on the form i.e.
matching the underlying column names? You may have to check
the property sheet for each control on the form(s) to ensure
it points to the right column (field).

When a form is not connected to any table it is described as
being unbound. When a record source is specified then it is
described as being bound to that table or query.

Good luck.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp is now Free
http://www.mrcomputersltd.com/ Repairs Upgrades

In blue typed:

 

[Rick Brandt]

I've created all the forms i intend to use for my database using only the
design view but double clicking on 'Create form in Design view'. But now
i've realised that none of my forms have any tables associated with them
which makes them completely useless!

How can i associate tables with my forms like i could have done if i had
used a wizard?

Enter the desired Table name, Query name, or SQL string into the Form's
RecordSource property. Then enter the desired Field names from that source into
the ControlSource properties of every control that needs to be tied to a field.

 

[Guest]

Thank you so much!

That worked perfectly, though i now know how i should be making forms which
will save alot of time!

I'll just go fix all my forms....

thanks again

blue

 

[Amy Blankenship]

You'll probably find it's quicker to start over from the wizard.