Creating a Variable Field in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to ACCESS and want a field that a user can enter in info. which will
search my database and then bring over specific info. related to that search
criteria. I understand the query side of it, but not on the creation of such
a field nor the macros that might have to be associated with it.
HELPPPPPPPPPP!!!
 
Any one want to tackle this one or get me started in the right direction OR
have I stumped you all???

Thanks
 
Are you trying to search everything in the database or one, or two tables?
If you have the query made that will search for the data, then you can set
the criteria of the field you want to base the search on to something along
the lines of:

Like ["Please enter search criteria."] &"*"

-
MATTHEW ELLIS
 
I simply have 3 fields on my form:

Field 1
Field 2
Field 3

I want Field 1 to work that someone enters a Keyword and Field 2 & Field 3
are proper populated with the specific info. from a table called OL.

That's it. So please help me formulate the code for this field as I quite
do not get your intention on your line of code.

thanks

Matthew Ellis said:
Are you trying to search everything in the database or one, or two tables?
If you have the query made that will search for the data, then you can set
the criteria of the field you want to base the search on to something along
the lines of:

Like ["Please enter search criteria."] &"*"

-
MATTHEW ELLIS
cckelly said:
I am new to ACCESS and want a field that a user can enter in info. which will
search my database and then bring over specific info. related to that search
criteria. I understand the query side of it, but not on the creation of such
a field nor the macros that might have to be associated with it.
HELPPPPPPPPPP!!!
Click to expand...
Click to expand...
 
cckelly said:
I simply have 3 fields on my form:

Field 1
Field 2
Field 3

I want Field 1 to work that someone enters a Keyword and Field 2 &
Field 3 are proper populated with the specific info. from a table
called OL.
Click to expand...

A three column ComboBox would do this in the simplest fashion. Just make
the first column the field you would have the user enter and in the the
AfterUpdate event of the ComboBox have code...

Me.Field2 = Me.Field1.Column(1)
Me.Field3 = Me.Field1.Column(2)
 
Back
Top