How to disable subform untill values selected in m

method · June 29th, 2005, 05:07 AM

How to disable subform untill values selected in main form?

Hi every body . I got a a form and sub form. I want to disable sub form untill the user finishes selecting values from combo box drop downboxes. I be happy if some one show me how to do this.

http://i5.photobucket.com/albums/y18...blesubform.jpg

(form picture)

leehambly · June 29th, 2005, 05:54 AM

Set the subform property called "Enabled" to "no", do this in design view.
Then put something like:

me.subform.enabled = Yes

in whatever combobox validation you have, so that when your user selects a record in the combobox it will "enable" the subform. You will probably want to refresh the data in your subform too.

method · June 29th, 2005, 06:33 AM

Quote:

quote:Originally posted by leehambly
Set the subform property called "Enabled" to "no", do this in design view.
Then put something like:

me.subform.enabled = Yes

in whatever combobox validation you have, so that when your user selects a record in the combobox it will "enable" the subform. You will probably want to refresh the data in your subform too.

Thank u for u reply. Well i got 3 combot boxes in my main form . Should i place the me.subform.enabled =yes inside code of each one of them ? Furthermore, could u tell me how to refresh my data in subfor? why do i need to do that. I only want it to display when the value for last combo box is selected by the user.Thanks

code behind the main form:

Code:

Option Compare Database

Private Sub CboEmployeeNo_AfterUpdate()
''pastse value of selected combo box to text label
Me.TxtEmployeeName = Me.CboEmployeeNo.Column(1)

End Sub

Private Sub CboYearWeek_AfterUpdate()

Me.TextWeekNo = Me.CboYearWeek.Column(0)
End Sub

Private Sub TextYear_AfterUpdate()
Me.TextYear = Me.CboYear.Column(1)
End Sub

leehambly · June 29th, 2005, 07:22 AM

Seriously, and this is only a personal perspective, but I think you really need to invest in a "How Databases works" book as well as a VB and Access book.

Ok, where you disable and enable the subform is totally up to you and how you want it work. If you want to trigger the enable from 3 combos, then go for it.

Why would you need to refresh... Im not entirely sure you would need to refresh, I merely said you would probably want to. The subform data is related to your comboboxes? I assume it is, but then I spose it doesnt have to be! If it is related to your comboboxes and the subform is disabled while you have been playing with the comboboxes, no doubt when you enable the subform it would be a good idea to refresh the data, wouldnt it? Test it out, see whether you need it.