Embedded Macro

[balajigade]

A newbie to Access 2007. Trying to pass parameters to a query alternatively from two combo boxes on a form : Combo0 & combo2 which provide the id no. & student name from look up tables respectively. Two option buttons facilitate the selection between the two combo boxes so that when one combo box is enabled, the other is disabled. A command button is there on the forum to make the query run. Without closing the form, I want that whenever I select one option (of entering the id no. or the student name) the other combo box should be reset to null. Suggest steps for embedding the code in the macro builder.



Thanks

[June7]

I don't use macros, only VBA. This would be so easy in VBA.

I think this has to be done with SetValue method in macro.

[balajigade]

Can you suggest the code. Not able to reset even after setting null value or " " in the default option of the combobox, unless I quit from the form and reopen it.

[June7]

These are unbound comboboxes used to input filter criteria?

The option buttons are radio buttons in an option group?

Set both comboboxes as disabled then user must click radio button to enable one?

Code behind option group AfterUpdate event, something like:

Me.combo1 = Null
Me.combo2 = Null
Me.combo1.Enabled = Me.option = 0
Me.combo2.Enabled = Me.option = 1

[balajigade]

Thanks. The combo boxes are bound to look up tables. I would like the command button to stay disabled unless at least one of the combo boxes is not null.This will prevent generating blank reports

[June7]

The comboboxes have RowSource that reference table, they are not 'bound' to the table. Binding a control means setting ControlSource property.

Use code in each combobox AfterUpdate event.

Me.commandbutton.Enabled = Not IsNull(Me.combobox1) Or Not IsNull(Me.combox2)

[balajigade]

Thanks Problem solved