|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Referencing Form Fields in SQL Queries
I have a Combo Box that I want the User to be able to select a field from. I then want to reference the field selected in part of an sql query.
So lets say for example, the combo box is named Field1 in form Search1. I want the sql statement in a query to do the following. Select * From Mydb Where Search1.Field1 > Value AND Search1.Field1 < Value; So I just need to know what i put in place of Search1.Field1. |
|
#2
|
|||
|
|||
|
I figured out what I was doing wrong.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Referencing Form Fields in SQL Queries |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|