Access Learner - Need Help with DoCmd.OpenForm to multiple criteria (1 Viewer)

[pbaldy]

Can you post the db here?

 

[F.I.G.]

Can you post the db here?

Thank you for your help. Please see attached.

 

[pbaldy]

There is no field in that table named TransactionID. Is this what you meant?

Me.cboTransactionType = DLookup("TransactionTypeID", "T_TransactionType", "TransactionType='" & strOpenArgs(1) & "'")

 

[F.I.G.]

What I want to achieve, when a user double on any selection in the list box, the value of the last column (new loan, renewal or amendment) to pass onto the unbound combo box "cboTransactionType" of F_LoanDocuments. Then that value will be the default value for "TransactionTypeID" of new record. Is that possible?

 

[pbaldy]

Did the code I posted do what you want?

 

[F.I.G.]

Did the code I posted do what you want?

Yes, yes, yessss, thank you! thank youuuuu!!!

 

[pbaldy]

Happy to help!

 

[F.I.G.]

Happy to help!

Hi Paul,

To better understand, I would greatly appreciate if you could explain the purpose of those apostrophes ( ' )

Me.cboTransactionType = DLookup("TransactionTypeID", "T_TransactionType", "TransactionType='" & strOpenArgs(1) & "'")

Thank you.
Van

 

[pbaldy]

For a text data type you add quotes. Without the concatenation, you'd have:

TransactionType = 'abc'

whereas a numeric data type would look like:

TransactionType = 123

The apostrophes I added were to achieve that.