Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Form Problem Help....

Hello,

I am trying to make a simple form that pulls a list from a tbl and link it back to a qry. But I keep running into problems.

Right now I have the following in my qry code
[forms]![frmSupLookUp]![txtBegDte]
the message i get is Microsoft Jeg database does not recogniz 'Forms!frmSupLookUp!txtBegDte' as a valid field name or expression. If i remove this parm it gives it to me for the next and so on... Is there something wrong with the forms info i am putting in the qry or is this a bug?

I am also getting this error

Run time error 3270
property not found... when i click the debug it gives me this... I am not seeing the problem... it does not like DoCmd.OpenQuery "QryDiscReasonRepDte", acViewNormal, acEdit ... thoughts ? I have double checked the qry name and even copied and pasted it into the code... and let the vb code enter all the rest... so i am lost...

Private Sub cmdRun_Click()
DoCmd.OpenQuery "QryDiscReasonRepDte", acViewNormal, acEdit
DoCmd.Close acForm, "frmSupLookUp"
End Sub


Any light you can shead would be great

Gina

Sign In or Register to comment.