Problem with data not showing in table

[Mattymoo]

I don't know how much detail to give here, but let me know if you need more.

I have three main tables
Client details
Claim details (one to many with client details)
pending details (one to many with claims) where is claim, date due to be
chased and received, yes/no

I have been entering information into the pending table via a sub form, but
when I look at the pending table the 'where is claim' data isn't there even
though the date due to be chased is. There doesn't seem to be a consistent
reason why some are showing and some aren't.

Any ideas anyone?

 

[John Vinson]

I don't know how much detail to give here, but let me know if you need more.

I have three main tables
Client details
Claim details (one to many with client details)
pending details (one to many with claims) where is claim, date due to be
chased and received, yes/no

I have been entering information into the pending table via a sub form, but
when I look at the pending table the 'where is claim' data isn't there even
though the date due to be chased is. There doesn't seem to be a consistent
reason why some are showing and some aren't.

What is the Recordsource of hte mainform? of the subform? What are the
Master and Child Link Fields? What exactly do you mean by "date due to
be chased"? and what by "where is claim"?

John W. Vinson[MVP]

 

[Mattymoo]

The main form is client details. Claim details is a sub form of client
details and pending details is a sub form of claim details.
The record source of client details form is tblclientdetails and the record
source of claim details isubform is tblclaim details. the record source of
pending details is qry pending table (a query so I can show some claim
details on the pending subform which is on a tab).

The master and child link field between claim details and pendingreason
subform are both claim ID. Date due to be chased is a field on my pending
subform, when I am due to chase up info if not received and where is claim is
pending reason.

THe subform allows me to select the pending reason without error, but just
doesn't show it when I go to the pending reason table.

I was wondering if it's a problem with my 'where is claim' combo box, which
has a control source of pending ID and a row source of pending reason ID and
pending reason?

Thanks for your help

Pauline

 

[John Vinson]

THe subform allows me to select the pending reason without error, but just
doesn't show it when I go to the pending reason table.

I was wondering if it's a problem with my 'where is claim' combo box, which
has a control source of pending ID and a row source of pending reason ID and
pending reason?

Probably. A Combo Box gets one or more (up to ten) fields from its
Rowsource query, and stores the field specified in the Bound Column
property into the Control Source.

I suspect you've been victimized by the Lookup Wizard. Are you
expecting to find the *text* of a reason in the Pending Claims table?
or the ID? Check the table definition and see if this is a Lookup
field; if so, the field will APPEAR to contain the text of the reason,
*but it doesn't* - it contains a meaningless numeric ID. It's easy to
get confused about which field to store in the table given this
misfeature!

John W. Vinson[MVP]

 

[Mattymoo]

No the table doesn't have a look up field. I just set up the combo box via
the form. THe combo box has pending ID as the control source and pending ID
and pending reason as the row source. Bound column is 1, column count is 2
and column width is 0;3.15. So my drop down box in the form looks right, but
something must be wrong if ithe selection is not feeding through to the table.

Any other ideas?

 

[John Vinson]

No the table doesn't have a look up field. I just set up the combo box via
the form. THe combo box has pending ID as the control source and pending ID
and pending reason as the row source. Bound column is 1, column count is 2
and column width is 0;3.15. So my drop down box in the form looks right, but
something must be wrong if ithe selection is not feeding through to the table.

Very odd. Please post:

- the SQL view of the Form's Recordsource (if it's a table, open it as
a query by clicking the ... and post the SQL; just don't save it when
you close the query window)
- The RowSource SQL of the combo box
- The Control Source of the combo box


John W. Vinson[MVP]

 

[Mattymoo]

Here's the SQL of the forms record source (it is a query)
SELECT [tblclaim details].[Adviser name], [Pending table].[Pending ID],
[Pending table].[Claims ID], [Pending table].[Client ID], [Pending
table].[Where is claim?], [Pending table].[Pending follow up date], [Pending
table].[Item received?], [Pending table].[Pending reason ID]
FROM [tblclaim details] INNER JOIN [Pending table] ON [tblclaim
details].[Claim details ID] = [Pending table].[Claims ID];

and the sql view of the row source from the combo box

The control source of the combo box is pending ID

SELECT [tbl lkp Pending reason].[Pending reason ID], [tbl lkp Pending
reason].[Pending reasons]
FROM [tbl lkp Pending reason]
ORDER BY [tbl lkp Pending reason].[Pending reasons] DESC;

Thanks
Pauline

 

[John Vinson]

Here's the SQL of the forms record source (it is a query)
SELECT [tblclaim details].[Adviser name], [Pending table].[Pending ID],
[Pending table].[Claims ID], [Pending table].[Client ID], [Pending
table].[Where is claim?], [Pending table].[Pending follow up date], [Pending
table].[Item received?], [Pending table].[Pending reason ID]
FROM [tblclaim details] INNER JOIN [Pending table] ON [tblclaim
details].[Claim details ID] = [Pending table].[Claims ID];

and the sql view of the row source from the combo box

The control source of the combo box is pending ID

SELECT [tbl lkp Pending reason].[Pending reason ID], [tbl lkp Pending
reason].[Pending reasons]
FROM [tbl lkp Pending reason]
ORDER BY [tbl lkp Pending reason].[Pending reasons] DESC;

Thanks
Pauline

I'm totally baffled then. This looks perfectly normal. If you open the
rowsource query in a datasheet do you see the expected values?

You might want to simply delete this combo box - or perhaps even the
form! - compact the database, and rebuild it. Something's messed up
but I cannot fathom what it might be!

John W. Vinson[MVP]