- Local time
- Today, 02:57
- Joined
- Oct 29, 2018
- Messages
- 21,477
Oh, I'm sorry. I thought you were asking me how to set up the Default Value. In reality, you were asking how to filter the form if VendorID was a text field. In that case, try the following instead.
Code:
DoCmd.OpenForm "VendorContacts", acFormDS, , "Me.VendorID='" & Nz(Me.VendorID,0) & "'", , , Me.VendorID