Access 2002 - Dynamic Textboxes

[Agnogan]

I'm working on a form that is going to have several different inputs depending upon what the user selects. In addition to this the user will be able to create new types of inputs as well.

With this in mind how would I go about creating specific textboxes on a form in Access 2002?

Basically I have to account for some input types that are not currently in the database, and I'm hoping there is a way to do this on the fly based on what the user has selected.

Thank you for the help!

 

[Chance1234]

you could account for the extras and use the .visible property on the controls on the form,

In the example below I have used the value of what a user selects in a textbox to determine whether to show combo_address which is another combo box on the form

Private Sub combo_Track_details_4_AfterUpdate()

    If txt_tracking_details_4.Column(2) = True Then
        combo_address_select.Visible = True
        combo_address_select.Requery
        combo_address_select.Locked = False
    Else
         combo_address_select.Visible = False
    End If
    
End Sub

in regards to inputs on the fly have you condisdered again using a combo box with the limittolist set to false allowing the user to enter in their own data ? also is your database tables relational, ?


Filmmaker, gentleman and Ambasador for London to the sticks.

http://WWW.5YLAC.S5.COM

 

[Agnogan]

The database tables are relational.

As for using the visible property, it looks like that will be what I have to do.

Thank you for your help Chance!!