SearchForm

[Ray67]

Hello

Build this form for the user to enter provider name and it would only display that provider. For some reason it's not working for me.

Database3.zip

Thank You

[June7]

Suggest you can simplify the form RecordSource to an SQL that pulls directly from table instead of a query object.

SELECT * FROM TOpenBalance WHERE PTLastName Like Forms!FTOpenBalanceForm.LastNameBox & "*";

The value of the combobox is ID, not patient name. If you want to search on name, remove ID from the combobox RowSource and change ColumnCount and ColumnWidths properties.

[Ray67]

I would need to pull my data from the query because i have
criteria setup. It doesn't show it on the sample db that i provided

Suggest you can simplify the form RecordSource to an SQL that pulls directly from table instead of a query object.

SELECT * FROM TOpenBalance WHERE PTLastName Like Forms!FTOpenBalanceForm.LastNameBox & "*";

The value of the combobox is ID, not patient name. If you want to search on name, remove ID from the combobox RowSource and change ColumnCount and ColumnWidths properties.

[June7]

Could put criteria in the form RecordSource sql statement.

I never use dynamic parameterized query. I use VBA code to construct filter criteria and apply to form Filter property or pass to form or report when opening.

[Ray67]

Got it to work

Thank you