Unbound list box

  • Thread starter Thread starter Simonglencross
  • Start date Start date
S

Simonglencross

Looking for a little bit of help as usual! :)

I have an unbound list box on my screen which is filled using a query as
follows :-

SELECT [MainScreenApps].[BeginTime], [MainScreenApps].[EndTime],
[MainScreenApps].[LastName], [MainScreenApps].[FirstName],
[MainScreenApps].[Salutation], [MainScreenApps].[AppointmentType] FROM
[MainScreenApps].

What I have also done is add a on dbl click event which then opens
Task/Appointment Form, this is where I get stuck! What I would like it to do
is then go to the record which I have just double clicked on.

Thank you all very much in advance.

Simon
 
Hi,
What field(s) define the record you clicked on?
In a normal scenario, the list box would have a column that has some sort of ID
(usually the primary key). So when using DoCmd.OpenForm,
you use the ID in the WhereCondition argument so that your other form opens
to the correct record.
However, if the ID field is part of your form's recordset, you can use that too.
Check out Help for the OpenForm method and in particular, the WhereCondition argument.
 
Back
Top