Query fields value of the Form are not saved in the table

[gcbeldar]

Please find the attachment of database. I have designed a form, used DLookup for values in the field of the Form. They are displaying as per my requirement. But "Only fields get Values from DLookup" are not stored in BillsTable.

Please Help. Thanks in Advance

[davegri]

Attachment 28558
See frmMaster in the attached DB. This is the form layout that you should use. Mainform/subform.
You don't need any lookups.

[gcbeldar]

Attachment 28558
See frmMaster in the attached DB. This is the form layout that you should use. Mainform/subform.
You don't need any lookups.

Thanks Sir,
Every Month, Bills are generated, just by entering "Present Reading" and "LoadConnected", "MinCharge", "RatePerUnit" are acquired by Master Table for TName selected in Bills Form. Other Fields are calculated as per requirement.

[aytee111]

What davegri said: Your table design needs some changes. In a normalized structure, data is never repeated. So all your dlookup's must be removed. If you need to know - for instance, what a bill's connected load is you will use the TName to link to the master table and get the information from there. Do not store the same data in two tables.

[gcbeldar]

What davegri said: Your table design needs some changes. In a normalized structure, data is never repeated. So all your dlookup's must be removed. If you need to know - for instance, what a bill's connected load is you will use the TName to link to the master table and get the information from there. Do not store the same data in two tables.

"LoadConnected", "MinCharge", "RatePerUnit" and "Tax" are changed in 9-15 months, and that will be changed in the Master Table as required.

Where as BillsTable is used to store information of all the values used at the time of Bill raised.

Anyhow, I have changed the names of Fields in two tables i.e., Master and BillsTable.

Now, every thing is working fine, Just want to know why the values derived by "DLookup" in the form are not saving in the BillsTable, but TName selected from the Master is saving (Working Fine) also values entered & Calculated in the Forms are saving in the BillsTable.
Unable find the solution to save the values derived by DLookup in the forms are not saved in Bills Table.

[gcbeldar]

Sir,
Also requested any other way like instead of DLookup, can Query can be used ?

[aytee111]

Fields need to be bound to a table. You do this by putting the table field name in the Control Source property - yours have DLookups instead so are not connected to the table in any way.