Hi
i'm very new to programming and access
thanks for help
i have a quotes table and (a child) job table, which relate on the quote # field.
I have client table which relates to different fields on both quote and job table
(for person who requested quote on quote table) and
(client project manager:,
bill to: &
ship to: on job table)
I have forms to enter data: Quote entry form with a Job Entry subform.
i concatenated three of the fields from the Client Table on the forms and also on some reports I created to show company, full name, and city on each of the client-related controls.
My problem (and i hope i'm describing all of this okay)
is that data that shows on the table is not always the same as data on the forms or reports.(example : an Approved Job report)
incidientally, the reports are based on queries based on the tables. I made bound controls and thought i linked them properly to the fields on the tables.
For example, if i view the table, the Ship to field will show John Smith, ABC Company, Los Angeles but when i print the report or view the form, the Ship to will say Karen Jones, AYZ Company, New York
One hint, John Smith will always incorrectly show Karen JOnes.
I sorted the bound controls and the queries by Company ascending. The bound controls are combo boxes.
One thing i may not have done was made the concatenation exactly the same in each control.
Any ideas? Help. We're using the data live at work and i'm just telling people to cross out the incorrect data on the reports for now. We're a small company but the data is quickly growing and i'd like to fix it as soon as possible.
Thanks for any help
Cathi Rimalower
ISI Translations
i'm very new to programming and access
thanks for help
i have a quotes table and (a child) job table, which relate on the quote # field.
I have client table which relates to different fields on both quote and job table
(for person who requested quote on quote table) and
(client project manager:,
bill to: &
ship to: on job table)
I have forms to enter data: Quote entry form with a Job Entry subform.
i concatenated three of the fields from the Client Table on the forms and also on some reports I created to show company, full name, and city on each of the client-related controls.
My problem (and i hope i'm describing all of this okay)
is that data that shows on the table is not always the same as data on the forms or reports.(example : an Approved Job report)
incidientally, the reports are based on queries based on the tables. I made bound controls and thought i linked them properly to the fields on the tables.
For example, if i view the table, the Ship to field will show John Smith, ABC Company, Los Angeles but when i print the report or view the form, the Ship to will say Karen Jones, AYZ Company, New York
One hint, John Smith will always incorrectly show Karen JOnes.
I sorted the bound controls and the queries by Company ascending. The bound controls are combo boxes.
One thing i may not have done was made the concatenation exactly the same in each control.
Any ideas? Help. We're using the data live at work and i'm just telling people to cross out the incorrect data on the reports for now. We're a small company but the data is quickly growing and i'd like to fix it as soon as possible.
Thanks for any help
Cathi Rimalower
ISI Translations
