Tiny Application

[davidebrownzvi]

I need a how-to for a very simple application-here it is:

1. On a form, display fields from a table in a list box (Ican do this)

2. Click on a line in the list box to select that record.

3. Click a check box to update a field in the record to "X" or blank.

4. Select another record, etc.

Thanks for your help.

 

[afloyd]

It might be easier just to display the records as a datasheet or using continuous forms. That way all the records are displayed and you don't have to mess with the list box.

HTH

-Al

 

[Cosmos75]

Create a Collumnar or Tabular form based on your table/select query.

Then go to design view, then click on the list box button and draw one out on the form (making sure that the button wizard is on) , then choose "Find a record on my form based on the value I selected in m list box". You will then be brought to a screen to choose the field you want to use to find that record and go ahead an add the field from the table/query the form is based on.

Lemme know if that works for you!

 

[Cosmos75]

davidebrownzvi,
Is this what you are trying to accomplish?

Access 2000 Version

 

[davidebrownzvi]

Cosmos75,

Thank you very much for your help. Using your example, I have exactly what I need.