Problem with Unbound text box

[mithani]

Dear All,

I will try to clarify my problem. If I am not clear, please let me know.

I have one form with subform. All text boxes are bound except DESCRIPTION, METAL, WGH/M. When I select any Die #, unbound text boxes take data from die table.

Whats happening, the first row is fine, but as I start filling my next rows, all DESCRIPTION, METAL & WGH/M changes every time whenever I select die #.

Please see the attached JPG, you can see all rows DESCRIPTION, METAL & WGH/M are same but infact it should not be.

I hope you understand.

Thanks

mithani

 

[MStef]

Hello mithani!

Look at "DemoUnboundFA2000.mdb" (attachment).
Look at Tables, Forms (frmMaterial, Record Source).
Open frmMainPROJECT ant try to enter records in
subform. Adapt it as you need. Look at Relationships.

 

[ajetrumpet]

Mithani,

if Stef's demo doesn't do anything for you, I have a few things to note...

First of all, you mentioned unbound text boxes. I don't see any text boxes in the jpg. All I see are 2 cbo's on the main form, and a subform based on a source table (or a query, I'm not sure which). If the subfrm is based on a query, I would first start to diagnose the problem by checking the SQL criteria...

 

[mithani]

Thanks MStef/ajetrumpet,

I have checked your demo but the DESCRIPTION, METAL & WGH/M you assigned as a bound. Let me tell you structrue of my database.

For this form, using three table:

1. Extrusion
die_number TEXT
die_description TEXT
metal TEXT
weight NUMBER

2. QUERY BASED ON TWO TABLES
2.1 tblInvoiceParent
InvoiceNO NUMBER
date DATE
project_code TEXT
etc

2.2 tblInvoiceChild
invoiceNo NUMBER
die_number TEXT
length NUMBER
qty NUMBER

You can see in my table tblInoviceChild, I am not saving description(die_description), metal or wgt/m(weight). These field are unbound and just to display and for calculation. My combo box calling die_number, die_description, metal & weight from extrusion table using select statment and display by using command (with the help of Bob):

me.description = me.comboDie_number.column(2)
etc

I would appreciated your help

Thanks

mithani

 

[MStef]

OK mithani, Look at another way I often use, (attachment).
Open "frmMainPROJECT2", (subform frmMaterial2).
You can see: "frmMaterial2" (subform) is linked on Table1Material, direct.
The fields "Description", "Metal", "WGHm", "UNIT", I have removed in
Form Footer. I don't know another way.

 

[mithani]

Thanks MStef,

I appreciate your help. Users need to see all description, metal & weight per row. In this case I think I have to include these field in my tblInvoiceChild table which is really not a professional step.

Please, is there any other way to solve this problem other than increase the unnecessary fields?

Thanks

mithani