Need help with writing Access Macro Expression

[qwerty]

I need help with writing the correct macro expression for my text box. I have a Query called QueryForm that is linked to my Form with the text box. In the Query there are two fields named PopMin and PopMax that has numeric values. The goal of the text box, if you enter 300 for population it is only going to show bird populations that are at 300. If the query is left blank, it is going to show all of the bird population in PopMin and PopMax. Can you please write an example of how this would be written in macro expression?

Given information:
Query Name: = QueryForm
Field Names = PopMin, PopMax


Textbox Name = TxtPop

[davegri]

if you enter 300 for population it is only going to show bird populations that are at 300.

Enter where? Show where?

If the query is left blank

Then you have no query. What does this mean?

Need MUCH more meaningful info to make any suggestion.

[qwerty]

Enter where? Show where?


Then you have no query. What does this mean?

Need MUCH more meaningful info to make any suggestion.

This is the for information to create the code,

Given information:
Query Name: = QueryForm
Field Names = PopMin, PopMax
Textbox Name = TxtPop

To create the code I gave you straight to the point information. You have the name of the query, the name of the fields in the query, and the textbox name....right above.

Can you help write a code for the textbox something like this....."Select PopMin, PopMax From QueryForm Where =>15 and <20 IF Null list all values in PopMin, PopMax....can you help me wright it in the correct format?"

[pbaldy]

May have been addressed here:

https://www.accessforums.net/showthr...240#post413240