etting the value of a control based on the value of another control 1

[thirty4d]

Hello,

I have a form in Access 97 that consists of textboxes, combo boxes, listboxes, etc where a user have to extract different values to create a partslist. Perhaps nine line items in a partslist, each task differs from another.

The first record is then transfered to the second form.

On the second form, user has to fill more data in order to make the record unique. The only thing unique is the location and function but everything else will be the same.

Repetitive fields are: Partnumber, Operation and Project Name.

How can I dynamically enter some of the repeating values to the fields above to reduce data entry?

Any suggestions is appreciated

Thanks

 

[Lightning]

Rather than duplicating your information in two tables, have you considered using a Form/Subform setup to enter the data? You can link the two forms using multiple Master/Child fields. Simply separate the field names with a semi-colon (. This would save duplication and effort.

HTH
Lightning

 

[thirty4d]

Lightning,

Thank you for your suggestion. Unfortunately my first form is already packed with different objects and no room to put my subform due to many variables in order to extract one complete record.

Again many thanks!

 

[Lightning]

Try using a Page Break control to set up a second page to your form if there are too many controls to display at once. Use command buttons or labels to toggle between each page as necessary.
While not displaying all info at once is inconvenient, it is certainly a lot better than duplicating data.

HTH
Lightning

 

[thirty4d]

Lightning,

Again, thanks for your suggestions. I never even considered about adding another page.