You need to provide more information. A form may be based on a query
comprising several tables, but it is unclear what you mean when you say you
"tried to put all my tables into a form". In what way exactly are you
attempting to do that, and what is the error message? What do you hope to
accomplish?
You need to provide more information. A form may be based on a query
comprising several tables, but it is unclear what you mean when you say you
"tried to put all my tables into a form". In what way exactly are you
attempting to do that, and what is the error message? What do you hope to
accomplish?
Im trying to create a form by using the form wizard. I have 33 tables
in my db and need all of them to create my 1st form.
When i tried to select fields from every single tables in the wizard
and clicked the Next button, i get an error "Subscript out of range".
What does that mean?
Im trying to create a form by using the form wizard. I have 33 tables
in my db and need all of them to create my 1st form.
When i tried to select fields from every single tables in the wizard
and clicked the Next button, i get an error "Subscript out of range".
What does that mean?
Stop. What you are attempting will never work. You cannot just combine a
whole bunch of tables into a single form. Certainly not if you expect to be
able to edit the data. A query with more than two tables will seldom be
editable and the more tables you add the smaller the likelyhood gets.
You should generally have a form per table that you want to edit and use
subforms and other lookup mechanisms to pull in data from other tables for
display.
Im trying to create a form by using the form wizard. I have 33 tables
in my db and need all of them to create my 1st form.
When i tried to select fields from every single tables in the wizard
and clicked the Next button, i get an error "Subscript out of range".
What does that mean?
I suspect a design flaw if you need 33 tables included in a form's record
source. Even without the error message you would almost surely be unable to
update the records. I don't know exactly what the error message means, but
a Google groups search for that exact text will produce quite a few hits,
one of which may apply to your situation.
With more understanding of what the database does I may be able to provide
some direction. You could try adding the fields one at a time until you
find one that produces the error, but again, I doubt a form that includes 33
tables in its record source will do what you need.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
