running a microsoft query or macro inside vba

  • Thread starter Thread starter mdavis
  • Start date Start date
M

mdavis

I am trying to call or requery a access query to be able
to update a veiw. I am pulling data.When a field value is
not in the veiw. ex order # 1001 is not in veiw. I want to
requery to see if the order will be there through vBA.
Then pull the order.
 
Hi,


If 0 = DCount("*", TableNameHere, "OrderNumber=1001") Then
' it is not in the table
End If


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top