Thread: setvalue macro
View Single Post
  #1  
Old November 13th, 2009, 02:48 AM posted to microsoft.public.access.tablesdbdesign
MTSmith
external usenet poster
 
Posts: 11
Default setvalue macro

I have a client record that when I push the events button I want a Events
Form to open up and automatically set the ClientID# so they can start
entering data. I read about the setvalue you can use in a macro, but I
cannot find the setvalue operation in the macro builder. The ex: is in the
help like this:

Echo Echo On: No Stop screen updating while the macro is running.
Close Object Type: Form
Object Name: Product List

Save: No
Close the Product List form.
OpenForm Form Name: Products
View: Form

Data Mode: Add

Window Mode: Normal
Open the Products form.
SetValue Item: [Forms]![Products]![SupplierID]
Expression: SupplierID
Set the SupplierID control to the current supplier on the Suppliers form.
GoToControl Control Name: CategoryID Go to the CategoryID control.

in the macro builder I choose Action of Open Form and I choose the Events
form. On the next line I open the box, but setvalue is not a choice. Am I
doing this wrong? Any help? Thanks in advance.

Terry Smith