access thread: on open go to a specifc record
Message #1 by "Ahmed Khamis" <akhamis@l...> on Thu, 26 Sep 2002 22:48:56 +0200
|
|
Good day All,
How can I force my form when it's opened, to start by
viewing a specific record with a specifc statues, lets say if I have 3
fields A,B,C so go to the fiest record where B and C are empty.
Pls help
Me
Thanx
Ahmed
Message #2 by "Carnley, Dave" <dcarnley@a...> on Thu, 26 Sep 2002 15:31:21 -0500
|
|
put some VBA code in the form's OnOpen event.
-----Original Message-----
From: Ahmed Khamis [mailto:akhamis@l...]
Sent: Thursday, September 26, 2002 3:49 PM
To: Access
Subject: [access] on open go to a specifc record
Good day All,
How can I force my form when it's opened, to start by
viewing a specific record with a specifc statues, lets say if I have 3
fields A,B,C so go to the fiest record where B and C are empty.
Pls help
Me
Thanx
Ahmed
Message #3 by "Steven White" <Steve.White@m...> on Fri, 27 Sep 2002 01:01:30
|
|
another option is to have the record source for the form be something along the lines of:
SELECT * FROM Table1 ORDER BY B,C;
This way you still get all the records in your table displayed, but the records with null values in
B and C are displayed first.
Steven
|
View Cart
