auto add

[turnej]

not sure if this is even possible but I would like to only display certain fields on a form depending on a criteria in another cell. For example if some enters 4 in 'Schemes' it would display 4 data entry boxes scheme1, scheme2, scheme3 etc - is it possible?

 

[catalin.petrut]

I know it's possible but you'll need help from someone who knows a lil of VBA. That is not me.

 

[turnej]

thanks hopefully someone who knows vba will reply

 

[catalin.petrut]

You know that all that "scheme" boxes should be fields on a table. Is there a limited number of schemes? Maybe you can use another strategy. Tell us more on what you need to obtain from the db.

 

[turnej]

Every record(customer) will have a different amount of schemes so my thinking was not to have unnecessary boxes on forms if they are not needed for that particular customer but for some customers they may be

 

[catalin.petrut]

I suggest another table, related to the customer table in witch you will enter the schemes using a subform.

 

[Monardo]

Hi,

Could you give more details on options and "data entry boxes", like :

if schemes=4 then sheme1 and sheme2 should appear
if schemes=1 then sheme3 and sheme4 should appear
etc.

Also are sheme1 ... schemeN bound or unbound textboxes (i.e. do they have table field behind) if bound, are they in the same table or another related table?

 

[missinglinq]

And really import, here, is what kind of Form are you talking about? Having Controls that are Visible or not can only be done in a Single View Form. With Datasheet and Continuous View Forms, formatting that appears on one Record appears on all Records.

Whether you need a separate Table for schemes depends on exactly what you're trying to do, here. A plain language explanation would help us help you.

Linq ;0)>