Selecting field value from another multivalue field
A second table [tblResults] records runners times for the event and has the following fields: resID, memID, evtID, resDistance, resTime.
I set the [resDistance] field as a combobox fetching the values from the [evtDistance] field but I just get a single line option with the values separated by commas (5,10,21,42) instead of separate lines for each value.
Is it possible to populate the resDistance field from the distances selected in the [tblEvents].[evtDistance] field? How?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
On a related note, I would like to create a calculated field that returns the number of values each record holds in the multivalue field
So I've successfully created several "variable" queries which will show individualized reports (based on employee selection via combobox/form) showing Individual Training Plan (which shows all documents regardless of training status), Training Overdue, and Training Required (but not overdue).
So with these queries/reports I can track IF an employee has been trained, but not when. I've tried creating before and after update rules which will "audit" the changes made to these two multivalue fields, compare the data before the change and after.
Then depending on the comparison, assign a date when an employee has been unchecked in the "Untrained" field. I will also need the ability to store and display this date for each document/employee in the reports. I keep getting errors saying that multivalue fields cannot be read.!
I have created a multivalue field which allows me to select many names which form s a circulation list for a report. The multivalue drop down works ox in table view, however when I am inform view the dro down is missing the check boxes.
I want to design such query with gives a report by selecting any field and the field which is not selected is automatically skipped
When I create a report to display the data, it displays it as 1,2,3.etc., instead of the names separated by a comma.
What do I need to do to display the names
User enters their login name in a field on a form. The form name is Login and the field is Text1. User clicks on a button, called Command1. Based on Text1, the form looks at the matching Associate field (ie, user enters michael and the record where Associate field is michael is selected) and its corresponding Pref1 field both which are in Table2. The Pref1 field holds a variable that determines which form opens up.
I presume the above is done with VBA for the Onclick event for Command1. What would the code look like? I realize a combo box would be easier than a text field but Im trying to make the db a little more secure by not displaying everyones login name
The user entering data enters all the invoices for a given supplier, instead of having to go find the supplier in the list every time he would like for the field value not to be reset to blank when creating a new record.
Can this be done