in simple terms on form1 i want users to click button two before button three is it possible?

[princess12]

Hello,




is it possible to have on form1 i want users to click button 1 before button 2 is it possible? the requirement is both buttons has to be on the same page.

i tried the attempt of button.enabled = true or false
but due to complexity of project according to me doesnt make it work.
the form is unbound

i want something like

If Forms!FormA!listbox!.ListIndex > 0 Then ( note this line is part of filter code section).

get users to click on button 2 before button 3

i even tried .....


If Forms!CheckAvailability!lstRoom.ListIndex > 0 Then <------ this line is also part of filtered applied to the next form
If Forms!CheckAvailability!lstRoom.OpenArgs = "cmdRoomAvailability" = False Then
Me!btnBookRoom.Enabled = False
Else
If Forms!CheckAvailability!lstRoom.OpenArgs = "cmdRoomAvailability" = True Then
Me!btnBookRoom.Enabled = True
End If


spent all night on this and dont know anymore.

please help, thank you





kind regards

[lfpm062010]

How about set button1.enabled = False on form open event and when button2 is clicked set button1.enabled = True in the button2 afterupdate event?

[princess12]

ok, thank you for your direction, but there is no afterupdate event on the property sheet where i can put my code in. there got on got focus, on enter, on exit etc.
i tried it on got focus, it works but then my listbox is not validated, meaning if listbox is not selected then dont call on got focus else if selected call on got focus.

[Perceptus]

Sometimes there are more events available in than you can see in the property sheet. If you are in the Code Editor, there are 2 drop down boxes above the code. Choose Button2 from the first drop down on the left, and AfterUdpate on the Right Dropdown.

http://catalogue.pearsoned.co.uk/ass...0273749218.pdf
See Page 16 Figure 2.12, shows the 2 drop down boxes I speak of. There should be similar ones in the VBA IDE.

[princess12]

i tried that right now and it not there, there is no after update or even before update

[princess12]

are there any alternatives to afterupdate of button, thanks

[June7]

Buttons don't have Update events. Use click event.

Are all these controls (buttons and listbox) on the same form? Is form in Single View?

[princess12]

yes all controls are in same form - single view. what am trying to do is check availability of rooms from listbox then transfer that information to the booking form to book the "available room" only, which is why i want users to click check availability button before booking buttons. how can i implement click event with this. i tried button.enabled = false or true. it doesnt work

here is the attached db

[June7]

Instead of forcing user to click a button to see availability, why not structure a combobox to list only those rooms that are available for given date?

Booking type database topic of numerous threads. Here is one https://www.accessforums.net/code-re...ays-49891.html


The MS Desktop Lending Library template probably has something like that - books that are already lent would not be listed as available. Desktop Asset Tracking template might also do the same.

[princess12]

thank you but that was not my requirement. however i want to thank you so much because of your suggesstion i found that i should have put the code in a different form, and now it works how it should be, thank you so much