search field in form that filter data from subform in form

[Userjan]

Good afternoon, ladies and gentlemen,
I've registered as a new member.
I'd like some help with some questions.
I've used Excel for years, but now it's unusable; sorting takes a minute.
So I switched to Access and spent four weeks struggling to create a similar database. While I'm fairly familiar with Excel, Access is more complicated.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
For example, in Excel, I had a macro called "if cell T6 is true (check mark) then call," which works well. This isn't possible in Access i think?
now i have try this but no data
button click [in_uit] Like "*" & [transacties_frm01]![subformulier transacties_qry01_ALL]![in_uit] Like "uitgaven"
the field is "in_uit" and the name that i search is "uitgaven"
-------------------------------------------------------------------------------------
the listbox is maybe a solution but complex i think?
now i search with
-------------------------------------------------------------------------------------
Like "*" & [forms].[transacties_frm01].[Oin_uitZoek] & "*"
Private Sub Oin_uitZoek_AfterUpdate()
Me.Recalc
Me.Oin_uitZoek.SelStart = Nz(Len(Me.Oin_uitZoek))
End Sub
--------------------------------------------------------------------------------------
greetings Jan

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[bob fitz]

Welcome to the forum

Can you post a copy of the db and tell us something about its purpose.

 

[June7]

Please post code between CODE tags to retain indentation and readability.

Mostly whatever you do in Excel could be replicated in Access.

Why would you need Recalc? Don't think I've ever seen this used.

Image of subform is not, it is image of query design view. Cannot reference listbox control in query.
Image of listbox does not even look like an Access listbox control.