Inputting a value

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

Guest

Some more help needed for a real VBA/SQL beginner. This must be an easy one!

What is the best way of arranging for a user to input their value for a
variable - I need the user to input a 4 character string into a variable
called Syllcode which I will then use in the WHERE clause of a SELECT query
and later in a DELETE query.

Any help much appreciated - as ever!

Jim Jones
 
Jim Jones said:
Some more help needed for a real VBA/SQL beginner. This must be an easy
one!

What is the best way of arranging for a user to input their value for a
variable - I need the user to input a 4 character string into a variable
called Syllcode which I will then use in the WHERE clause of a SELECT
query
and later in a DELETE query.
Click to expand...

I'd use a form with an unbound text control and reference that control in
any
calculations.

Tom Lake
 
Back
Top