Tables not updating

  • Thread starter Thread starter Chico
  • Start date Start date
C

Chico

I have placed in my form a ComboBox(Field 0: UIC) which
once you pick a selection, it automaticaly filled two
other fields (Field 1:Name of UIC)(Field 2: Location of
UIC). Everything works wonderfully! The problem is that
when I add a record, the field that is automatically
filled doesn't show in my report. I have to open the
table and add it manually for it to show in my report. I
have changed the 3 fields for Lookup (in the table), but
it is not working. Because this database will be protected
and data entry performed by a third party, I have set it
up to work directly from the form and print reports. What
am I doing wrong? Can anyone help me on this? I've tried
everything that I can think of. Need another pair of eyes
or brain.

Thank you

Chico
 
Chico said:
I have placed in my form a ComboBox(Field 0: UIC) which
once you pick a selection, it automaticaly filled two
other fields (Field 1:Name of UIC)(Field 2: Location of
UIC). Everything works wonderfully! The problem is that
when I add a record, the field that is automatically
filled doesn't show in my report. I have to open the
table and add it manually for it to show in my report. I
have changed the 3 fields for Lookup (in the table), but
it is not working. Because this database will be protected
and data entry performed by a third party, I have set it
up to work directly from the form and print reports. What
am I doing wrong? Can anyone help me on this? I've tried
everything that I can think of. Need another pair of eyes
or brain.
Click to expand...

I assume the UIC information comes from a UIC table.
If both the form and the reports are based on a query joining the two table
on the UIC fields in both, then all you have to do is drag the proper fields
to your report.

If you are using any sort of code to update the fields, it sounds like your
code is wrong.
Code is neither necessary or a good idea for what you want to do.

Posted from 10 miles West.
of Chico
California, that is...
 
I must do something wrong or take the wrong field, because
it does not work. I have a table of UIC and a table for
the form. (Please note that I have included in the second
table, 3 fields of my UIC table, I guess I duplicated the
work). Maybe my mistake is there. Because I am not sure
which field I should drop in my form. The one from my UIC
Table or the one that I have inserted in the Form table
(Which is the same information of the UIC table).

I hope I don't sound too confusing.

Thanks

Chico
 
I must do something wrong or take the wrong field, because
it does not work. I have a table of UIC and a table for
the form. (Please note that I have included in the second
table, 3 fields of my UIC table, I guess I duplicated the
work). Maybe my mistake is there. Because I am not sure
which field I should drop in my form. The one from my UIC
Table or the one that I have inserted in the Form table
(Which is the same information of the UIC table).

I hope I don't sound too confusing.
Click to expand...

Your query would look something like this and the UIC field from the Form
table is the one you fill in and keep.

SELECT [Form Table].ID, [Form Table].UIC, [Form Table].datin, UIC.[UIC
name], UIC.[UIC something]
FROM [Form Table], UIC;
 
Back
Top