Create a table from an existing form in Access 2003

  • Thread starter Thread starter centre21
  • Start date Start date
C

centre21

I hope someone knows the answer to this:

I recently created a form in MS Access. Due to the complexity of the
form, I created the form first, with the intention that I would just
create an associated table later, to save the data entered into the
form. Unfortunately, I cannot see a way to make this happen. Anyone
run into a similar problem?
 
centre21,

I answered your other post about saving a record. I did not go into "form
first table second" in that posting but I see you have mentioned it here.
Normally, one creates the tables needed first then builds the form as the
table is the RecordSource of the form. You are now going to have to create
the table/s, then a query, assign that as the RecordSource and then
associate all the fields.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
I hope someone knows the answer to this:

I recently created a form in MS Access. Due to the complexity of the
form, I created the form first, with the intention that I would just
create an associated table later, to save the data entered into the
form. Unfortunately, I cannot see a way to make this happen. Anyone
run into a similar problem?
Click to expand...

IF - and it's a *very* big if! - your form is designed so that it can use only
one table, and that one table is properly normalized - then you can create the
table in table design view; open the form in design view; set its Recordsource
property to the name of the table; and then set the Control Source of each
textbox on the form to the appropriate field in the table.

If, as is more likely, you have multiple combo boxes looking up data in other
tables, subforms editing data in other tables, etc. you'll have to deal with
each of these individually. It may or may not be simpler to just start over!
 
Back
Top