I have a query that returns a list of records sorted by date/time descending.
The first record in the query will be the most recent.
In a form for data entry I want to select the values from the last instance of data entered using Dlookup to select the first record frm the above query, something like:
DLookup("[Field]", "Query", criteria to select the first record from the query)
...
Aidan
Last Activity: Apr 4 '07, 02:36 PM
Joined: Sep 19 '06
Location:
-
No help either...this is the row source of one of the controls being requeryed:
SELECT tblTrainingModu les.ModuleCode FROM tblTrainingModu les WHERE tblTrainingModu les.POPCode = Forms!frmTraini ngSessions1.POP Code
make any difference? -
Hi,
sorry i have been away for a few days.
there is a simple code on the combo to requery the 2 controls that i am having the problem with, its placed 'OnChange':
Private Sub POPCode_Change( )
Me.ModuleDescri ption.Requery
Me.ModuleCode.R equery
End Sub
You think this could be thew problem?
thanks
AidanLeave a comment:
-
thanks, but it still doesnt change things, when i arrow to the next record after entering details, the values in the controls that dont update stay on the form - mean anything to you?
Thanks again,
AidanLeave a comment:
-
the control source for each control is set to the appropriate field of the table.
Also, the bound column is set to 0.
The value that is selected is from an SQL statement in the controls row source. This is requery-ed after selection of the value in the first combo.
baffling!...Leave a comment:
-
I have a form to create a new record for a training course.
The first combo box on the form allows selection of the course POP code and this then fills details on 2 list boxs for course module code and description.
Problem: the 2 controls above are not taking the requery-ed value through to the table. The proper data is displayed on the form but when i look at the table being updated, the data is not present. If i (mouse) click...Leave a comment:
-
thanks,
true that it was not needed, it works fine with just 1 primary key.
cheersLeave a comment:
-
Data Entry Form - Index/Primary key null value
I have a form to create a new record for a training course. The form is based on one table that has 4 keys set to primary key.
The first combo box on the form allows selection of the course POP code and this then fills details on 2 list boxs for course module code and description. The course section can then be selected from another combo box (filtered by the value in the first combo box) . Finally the course session name is entered... -
I have set all 3 listed fields in tblTrainingSess ionAttendance as the Primary Key and the index on all of them is, as you say, set to duplicates ok. The 3 fields combined will create a unique key for each staff member attending a particular course. I dont understand where the conflict is arising from.
Thanks,
AidanLeave a comment:
-
Key Violations
i am creating a database for organising training courses and logging staff attendance.
Tables:
1. TrainingSession s(primary keys: POPCode, ModuleCode, Section, SessionCode)
2. TrainingSession Attendance(prim ary code: SessionCode, Team, StaffCode)
3. StaffList table (primary keys: StaffCode & Team).
The relationships are:
many to one form 1 to 2 across the SessionCode field....
No activity results to display
Leave a comment: