OfficialChad
New member
- Local time
- Today, 14:20
- Joined
- Feb 13, 2020
- Messages
- 23
So i am trying to get my "sub form" to change to the data the user enters i know this is something you can do when you use a forum as a sub form but my "sub form" is coming from a qry as senn in "Annotation 2020-03-04 004253.png". Im not sure why i keep getting this see "Annotation 2020-03-04 003725.png"
this is the code.
if anyone would kindly be of help i am new to access and some what new to coding
Here is the code:
this is the code.
if anyone would kindly be of help i am new to access and some what new to coding
Here is the code:
Code:
Private Sub numsearch_AfterUpdate()
Dim PhoneSearch As String
PhoneSearch = "select * form contacts where ([Mobile Phone]= " & Me.numsearch & ")"
Me.qryContactsExtended.Query.RecordSource = PhoneSearch
Me.qryContactsExtended.Query.Requery
End Sub