Making Buttons Appear based on Combo box item selections

[Steven19]

Hi

I have a database where I have a table with sime fields that are fields for a UK Storage Cert, A UK Distribution Cert, A UK Vat, and an International Storage Cert and an Internationa Distribution Cert.

I have a form where the user enters the customer address, and the enter the company address.

I would like it that if the country = untied kingdom, then the buttons for UK Storage Cert, UK Distribution Cert A UK Vat cert will be visible, and if the enter another country value then International Storage Cert and International Distribution Cery are displaed.

There are other variations but these should be enough to get me started.

How do i make specific buttons visible based on the value of a combo box saved in the footer?



Regards

[June7]

Something like:

Me.UKbuttonname.Visible = Me!country = "United Kingdom"

Me.NotUKbuttonname.Visible = Me!country <> "United Kingdom"

Real trick is figuring out what event(s) to put code into.

Also, this setting will apply to all records.

[isladogs]

you can also use the tag property for this.
Assign the value UK to the tag property of all the UK buttons and INT to the other buttons.
Then use code similar to that in my SetControls demo app to update the button visibility in one line of code.
The code should be added to the after update event of the combo.

See http://www.mendipdatasystems.co.uk/s...ols/4594398114 for the demo app.

[Micron]

If there are a lot of "other variations" you might want to use a Select Case block in the combo AfterUpdate event.

[Steven19]

I decided to go with the below for which I had to remember to specify the array of my combo box presently giving me the data.

Private Sub Form_Load()
If Me.Country_Lookup.Column(1) = "United Kingdom" Then
Me.Wowgrbtn.Visible = True
Else
Me.Wowgrbtn.Visible = False
End If
End Sub

Glad it worked, thanks for all your advice everyone.

[Micron]

Might interest you to know that this sort of thing will usually work too (just for future reference)

Private Sub Form_Load()
Me.Wowgrbtn.Visible = Me.Country_Lookup.Column(1) = "United Kingdom"
End Sub

which is basically what June7 suggested. BTW, if your form displays only single records and you're going to navigate from record to record, your code isn't going to do what you need.

[Steven19]

Hi Micron

The way this database is being designed is that it is a process flow database. The user will only be able to work on one record at a time with this setup. Basically it leads the user through some complex legal checks that have to be completed. So the user is asked the company country of operation, then determines which buttons are displayed, which in turn will determine sub buttons, then the user fills out the relevant sections. But they can't jump from process to process as they have a report at the end that needs to be PDF'd and sent to our Gov for approval.

I have a continuous form which lists types of companies with control buttons to open the database up further for a much bigger edit.

However I have kept notes of both versions for future reference.

Thank you.