subform is missing one related table.

G

Guest

I have a form with two subforms. It took me all day to get it right.
I don't want to do it over. On one subform there is a small related table
with one field that I left off. I tried adding the field and of course it
doesn't show up in the fields list. There must be an easier way to do this
in a query so you don't have to keep redoing the form.
Is there a way to add one more table to a subform so I can edit the form?
I have one main table with two related tables and the related tables have
related tables. I tried one big query with all the fields of all the tables
on it and that didn't seem to work. So I just break up the related tables
into groups and make the queries that way then base the form and subforms on
the grouped related tables?
thanks,
 
J

John Vinson

I have a form with two subforms. It took me all day to get it right.
I don't want to do it over. On one subform there is a small related table
with one field that I left off. I tried adding the field and of course it
doesn't show up in the fields list. There must be an easier way to do this
in a query so you don't have to keep redoing the form.
Is there a way to add one more table to a subform so I can edit the form?

Do you need to edit records in both the table and the "small related
table"? Or do you just need perhaps a Combo Box based on the small
related table, displaying a human-readable value and storing a
computer-meaningful key value?

What are these tables, and why do you need to base the Form on both of
them?

John W. Vinson[MVP]
 
T

tina

On one subform there is a small related table

do you mean that the subform is *bound to* this small related table? if so,
take a look at the subform's RecordSource property. does it show *only* the
name of the table? or does it show "SELECT..."? if the latter, then the form
is bound to a SQL statement. click on the Build button (...) at the right
side of the property, which will take you into a screen that looks like a
query design view. add the new field to the query grid, close, and save the
form.

on the other hand, if the subform's RecordSource property shows only the
name of the table, then the new field *should* show up in the form's Fields
list. if it doesn't, my first guess is that the culprit is the Name
Autocorrect option (if you're using Access 2000 or newer). suggest you
create a new, blank database. immediately turn OFF the Name Autocorrect
option, under Tools | Options | General tab. compact the database. import
all the objects from your current database into the new one, then compact
the new db again.

hth
 
G

Guest

Hi John
you guessed correctly it is just a small related table for a value list for
a combo box.
I'm guessing from your email that you can add the combo box
 
J

John Vinson

Hi John
you guessed correctly it is just a small related table for a value list for
a combo box.
I'm guessing from your email that you can add the combo box

I didn't send an EMail, I posted to a newsgroup. They're different.

Yes, you can use a Combo Box on a form. It is not necessary nor
appropriate to include the combo's rowsource table in the Query upon
which the form is based.

Note that using a Value List is less flexible and harder to keep up to
date than using a related table as the source of a combo - it's not
clear to me which you're doing!

John W. Vinson[MVP]
 

Ask a Question

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.

Ask a Question

Top