Evaluating a Table Value

[Carmine]

I’m just attempting to learn Access VBA. So here’s the problem:
I want to set up an IF-Then statement to evaluate the contents of a field in a table.

Table name is: MasterTable
Field name is: Option
The value of Option is 1,2, or 3
What I’m trying to do is execute the following If-Then statement:



If option=1 then open a query
This is to be executed on a button click

Below is what I’ve done, but it doesn’t work. I get Run Time Error: 424
Object required.

Private Sub Command9_Click()
If MasterTable.Option = 1 Then DoCmd.OpenQuery "GallonUpdateQ"
End Sub

Thanks

[madpiet]

I’m just attempting to learn Access VBA. So here’s the problem:
I want to set up an IF-Then statement to evaluate the contents of a field in a table.

Table name is: MasterTable
Field name is: Option
The value of Option is 1,2, or 3
What I’m trying to do is execute the following If-Then statement:

If option=1 then open a query
This is to be executed on a button click

Below is what I’ve done, but it doesn’t work. I get Run Time Error: 424
Object required.

Private Sub Command9_Click()
If MasterTable.Option = 1 Then DoCmd.OpenQuery "GallonUpdateQ"
End Sub

Thanks

That doesn't make sense. You'd have to read a specific record... then maybe that would work. If you base a form on the table, and that record is current, then you could do it. Otherwise, you'd have to filter the table. I would start with just controls and not try to deal with records yet. It's a lot easier to start there.

[June7]

Can't reference a table/query (filtered or not) directly like that in VBA. Use code to open a recordset or use DLookup() domain aggregate function or reference a control on bound form.

Instead of opening table or query objects, should probably open forms or reports.

[CJ_London]

Assuming your master table contains only 1 record then use the dlookup function to get it

If dlookup(“option”,”MasterTable”)= 1