Forum Home
Press F1
Thread ID: 121165	2011-10-14 03:50:00	Access Database lookup/select on input form	Mike (15)	Press F1

Post ID	Timestamp	Content	User
1237476	2011-10-14 03:50:00	Hi, I have an Access DB with a table of people with all their vital information (address, phone, etc. etc.) with first/last in separate fields. I want another table that records a meeting date and who was there (probably just 'Date', 'First', 'Last' per line, so multiple records for the one meeting date, but that should be OK I think?) - I'm wondering how I go about creating the input form so that it lets me enter the date and select the people at the meeting without having to type in each of their names... Does that make sense? Contacts: PersonID First Last Phone 1 Mi Ke 1234567 2 Ek Im 7654321 Meetings: Date PersonID 10/10 1 10/10 2 11/10 1 12/10 1 12/10 2 Any suggestions on how I can go about doing this? Can I do a multi-input for attendees that will write to multiple records? Can I have a drop-down to pick attendee names rather than typing them in? I won't be using the form to add new people, just pick who was there on a particular day. Cheers, Mike.	Mike (15)
1237477	2011-10-14 05:18:00	A list box or combo box will do the trick for you. Combo box involves at least 2 mouse clicks per entry, plus scrolling if the list is long. A list box eats more screen area, but needs only a single click (and scrolling if the list is long) In the properties for the List/Combo you'll need to define a query for the Row Source property. Ideally the query will contain PersonID, First, Last from your Contacts table, sorted alphabetically on First or Surname. The Column count would need to be 3. Bound Column 1 (assuming PersonID is the first field of the query) Column widths could be something like 0;3;3 (assuming you're set to use cm) Use 1;3;3 if you wish to see the PersonID in the List/Combo Box. The Control Source of the Combo/List box is PersonID of the Meetings table. Getting a list of dates is more of a challenge, which I won't attempt. If you want to be a clever bugger, then you could leave the Combo/List box unbound, and have a macro attached to it which will write the PersonID to the table the moment you click a name... which speeds up multiple selections. Ideally set the meeting date first, then simply duplicate the date automatically each time a PersonID gets added. Manually update the date whenever you start on the next meeting date. What happens if there's more than one meeting per day though?	Paul.Cov (425)
1237478	2011-10-14 06:08:00	Thanks I'll have a play and see whta I can come up with :) What happens if there's more than one meeting per day though?Never will be, so I'm safe there :) Cheers, Mike.	Mike (15)
1