Unwanted Brackets in MS ACCESS 2000 Macro Desginer

[Kevin Chen]

I am trying to desgin a very /very/ basic macro to create a purchase order
form for specific suppliers. To do this I need to have a macro that checks a
value from the Purchase order form as a condition before adding it to a text
box on the purchase order form.
What I want is this
Forms![PurchaseOrder]![SupplierID]=DLookUp("[OrderItemSupID_1]","OrderInformation","[OrderID] = Forms![PurchaseOrder]![OrderID]")

After I type, paste, or build that expression, I get thi
[Forms]![PurchaseOrder]![SupplierID]=DLookUp("[OrderItemSupID_1]","OrderInformation","[OrderID] = Forms![PurchaseOrder]![OrderID]")

I have had this problem repeatedly and I can't get MS tech support to help
without it costing me $99+

Can anyone help? This project is due soon and I don't have a lot of time to
learn more advanced programming (VBASIC)

 

[Steve Schapel]

Kevin,

It is not really clear what you are doing. As far as I know, it is not
possible to create a form using a macro, and certainly not a basic
macro. What is the context of how and where you are using the
expression you gave us? What problem are yoiu experiencing? The only
difference I can see in the "before" and "after" versions is the []s
around the word Forms. Whereas it is probably more correct to have the
[]s there, I expect it should work exactly the same with or without. I
can't follow the purpose of checking a value on a form so you can add
the same value to the same form?

 

[Steve Schapel]

Thanks, Kevin. Pleased to know that you have got it working now. I
would suspect that the original problem was somewhere else, in fact, and
not related to the expression.