Should I make access save the data in the list box to a seperate table or should I let it store the values for use later? If it stores the values, how do I recall them? I would like it to put in a new appointment in the table in order to facilitate the use of timetables...should I just use an update query which takes its values from the form or what should I do?
List Boxes
- Thread starter majury221
- Start date
Wiz47
Learning by inches ...
- Local time
- Today, 02:53
- Joined
- Nov 30, 2006
- Messages
- 274
Where does the listbox get its data from now? If you are using a form with unbound fields, then you might want to bind them to fields in a table. This will allow you to update the listbox using that form and save new entries for later use. I use this method to view and update a listbox that contains business contacts.
The list box gets its values from a table at the minute, it displays the Customer Forename, Surname and Address and another list box displays the Mechanic forename and surname. I want to be able to enter appointments for a specific customer, and select the mechanic from the list box...is this possible?
Wiz47
Learning by inches ...
- Local time
- Today, 02:53
- Joined
- Nov 30, 2006
- Messages
- 274
Is it possible to upload a stripped down version of the db? From your description, it sounds like you want to use a separate form for the appointments. You could do that on a click or double click event from the main listbox then use a combobox in the pop-up form to select the mechanic and use textboxes or other combo boxes for other items pertaining to the appointment.
I use a similar method to add contacts to a main listbox. If I doubleclick on the selection in the listbox, it pops up a form with the details of the contact which I can edit or add records to. You could do the same thing, but have it for appointments instead.
