JeffCoachman,
I saw your sample. However, my problem here is a bit different since I'm trying to set the default value to be a value in the table that matches to the caseID instead of the caseID itself. So, instead of
Private Sub cmdOpenFormB_Click()
DoCmd.OpenForm "FormB", , , , , , Me.txtFormACaseID
End Sub
Should I replace "Me.txtFormACaseID" in your code with the query name that I designed to get the value?
How can I do that then?
Really need your help! Thank you very much!
Main Topics
Browse All Topics





by: boag2000Posted on 2008-06-26 at 23:16:47ID: 21881276
angie_angie,
Here is one way:
JeffCoachman
sample