Query Results in Data Entry Form Not Sticking

[Rich Ellis]

My orginal question was this:

Hi,

I have a form which is linked to a table(tblAntibody) for data entry.
I have another table(tblCatalogPartNumbers) with no relationship to
the first which contains all of our codes and has four coulmns
CatalogNumber, UnqualifiedNumber,NIPartNumber, and PIPartNumber. All
of these columns store thier data in tblAntibody.


On the form CatalogNumber is a combo box that has it's selection
criterial set to tblListCatalogPartNumbers. Once a catalog number is
selected, the form is refreshed. Now the other 3 list boxes get thier values
via a query on tblCatalogPartNumbers with the criteria of what the catalog
number currently listed on the form is. Ok great I can now see them on the
form. WHen I save the record, the queried values do not save to
tblAntibody(The table the fields are bound to)

Any ideas why?

*Bangs head against wall wishing he knew VBA better *

 

[John W. Vinson]

My orginal question was this:

Hi,

I have a form which is linked to a table(tblAntibody) for data entry.
I have another table(tblCatalogPartNumbers) with no relationship to
the first which contains all of our codes and has four coulmns
CatalogNumber, UnqualifiedNumber,NIPartNumber, and PIPartNumber. All
of these columns store thier data in tblAntibody.

That last sentence makes no sense.

A Table is a repository for data. A column contains data. It doesn't and
cannot "store data in tblAntibody" or anyplace else.

Do you mean that these are Lookup Fields - which *contain* a concealed numeric
ID, but *display* data from a lookup table?

On the form CatalogNumber is a combo box that has it's selection
criterial set to tblListCatalogPartNumbers.

What is the Row Source of this combo box? Could you please post the SQL?

Once a catalog number is
selected, the form is refreshed. Now the other 3 list boxes get thier values
via a query on tblCatalogPartNumbers with the criteria of what the catalog
number currently listed on the form is.

A query? Or three queries?

Ok great I can now see them on the
form. WHen I save the record, the queried values do not save to
tblAntibody(The table the fields are bound to)

Again: what are the RowSources of these controls? What are their Control
Sources? What is the Recordsource of the form?

Any ideas why?

*Bangs head against wall wishing he knew VBA better *

Well, nothing you've posted here has anything whatsoever to do with VBA...
just with queries and form properties. Or am I missing something?

John W. Vinson [MVP]

 

[Rich Ellis]

That last sentence makes no sense.





A Table is a repository for data. A column contains data. It doesn't and
cannot "store data in tblAntibody" or anyplace else.

Do you mean that these are Lookup Fields - which *contain* a concealed numeric
ID, but *display* data from a lookup table?


What is the Row Source of this combo box? Could you please post the SQL?


A query? Or three queries?


Again: what are the RowSources of these controls? What are their Control
Sources? What is the Recordsource of the form?


Well, nothing you've posted here has anything whatsoever to do with VBA...
just with queries and form properties. Or am I missing something?

John W. Vinson [MVP]

Hi John,

The row source for these list boxes are the 3 queries (1 for each).


So the fields store thier data (and the fields are bound to) columns in
tblAntibody. The row source is the free standing table tblCatalogPartNumbers.
I am doing this all through the Access 2003 front end. This is the result of
me trying to get the UnqualifiedPartNumber, NIPartNumber, and PIPart Number
to auto populate once a selection is made in the CatalogNumber field.

So essentally what you have is the catalog number is a combo box pulling
it's values from the column CatalogNumber in the tblCatalogPartNumbers. On
the form the other 3 fields are list boxes that pull thier data from a
query(1 seperate query for each field) that says "Take the selected catalog
number on the form and match that catalog number in tblCatalogPartNumbers,
then pull the data for X field (Unqualified Part Number,
NIPARTNUMBER,PIPARTNUMBER) that corresponds to the part number. Here is the
query SQL:

SELECT qryfrmOEtblListCatalogPartNumbers.UnqualifiedPartNumber,
qryfrmOEtblListCatalogPartNumbers.CatalogNumber
FROM qryfrmOEtblListCatalogPartNumbers
WHERE
(((qryfrmOEtblListCatalogPartNumbers.CatalogNumber)=[Forms]![frmOrderEntry]![CatalogNumber]));


Anyhelp is appreciated