How would I code this

[tl mike]

I need a little MVB help.

I need to code the following string for a back order module:

Dim strNewOrderPK As String, strOrderPK As String
strOrderPK = [OrderPK]

string (strNewOrderPK) = New Order (OrderPK) (is equal to) New Orders Back OrderPK (BOOrderPK) (that is the same as) Old OrderPK (strOrderPK)


Thanks

 

[HiTechCoach]

Does MVB mean MS Access VBA?

Unfortunately, without knowing a lot more details about your database, it will be impossible for us to give you any specific help with your database.


You might want to create some custom User Defined Function(s) where you pass the primary key and it returns what you want.

Can you post a sample of your database with sample data?