spectrolab
Registered User.
- Local time
- Today, 16:34
- Joined
- Feb 9, 2005
- Messages
- 116
Hi all,
I need to add some data to a table using a form that has slightly different fields that need to be entered depending on who the data is for. It is used to enter data based on a particle size analysis and we have a lot of different screen sizes, not all of these are used for each customer.
For example, one customer might have 31.5mm, 6.3mm and 0.15mm data that needs to be entered into the table, whereas another customer might need 10 or so size fractions entered. Currently the form we use has all of the fields shown, which makes data entry clumsy and prone to mistakes. The records shown in the form are based on a query which selects a particular job from a drop down list.
Is there any way that we can only show the required fields in the form based on the particular customer requirements? Or, if it easier, have a series of check boxes to only show the fields selected in a sub-form?
Thanks in advance.
I need to add some data to a table using a form that has slightly different fields that need to be entered depending on who the data is for. It is used to enter data based on a particle size analysis and we have a lot of different screen sizes, not all of these are used for each customer.
For example, one customer might have 31.5mm, 6.3mm and 0.15mm data that needs to be entered into the table, whereas another customer might need 10 or so size fractions entered. Currently the form we use has all of the fields shown, which makes data entry clumsy and prone to mistakes. The records shown in the form are based on a query which selects a particular job from a drop down list.
Is there any way that we can only show the required fields in the form based on the particular customer requirements? Or, if it easier, have a series of check boxes to only show the fields selected in a sub-form?
Thanks in advance.