Recent content by viperpurple

Thanks for that John, it gives me confidence that i seem to have been heading in the right direction. As i said earlier i posted this is the VBA forum as that's what i've been working on so far but with limited success. The below thread details my VBA code that i am trying to use...

Thanks Paul, I understand how that works, i am however wanting to select multiple items to do this with at the same time and then also let the user see what was previously selected when they revisit the form. Sorry i realise that i didn't make this totally clear. I guess you could do this...

Hey, I am creating a database of all the equipment that we have and also a record of when it is checked for safety and inventory. I would like to have the primary key (from another table) stored in the database but the description for each item been shown on the form to the user that relates...

How do you use the primary key to look up data in another field on the same record and then display that on the form?

I am creating a database of all the equipment that we have and also a record of when it is checked for safety and inventory. I am currently having problems getting the primary key stored in the database but the description for each item been shown on the form to the user. I have currently got...

just figured the reason for the error, see the edited reply above

Bob i just tried your suggestion and it just makes my list box show 'SELECT equipment_checked FROM tbl_equipment_checks' rather than looking in the table. I guess this is because it just sees it as a string, i tried removing the quotes but then it hasn't been told where the recordset is so it...

Hey, I get a 'type mismatch' error when i run this code, the field 'equipment_checked' is of type 'memo' and i understand that the rowsource can only hold 2048 characters but i have no idea how to get around either issue. The idea is that i am using a list box to display data on a form and...

Just for your interest i managed to solve the problem, just got to tune it now but the correct code that works is below. Thanks for your help :-) Private Sub Form_Current() Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim strsql As String Dim strname...

Thanks Jal, I've taken that code and fixed it for syntax and got it nearly working but i keep getting a fault on the last line involving the below info. Problem: 'rs.check_date.Value' Error: Method or check data not found Thoughts: I guess that it's not finding the data in the query, could the...

Hey, Objective I am creating an equipment database and this includes recording when the equipment is checked for damage etc. I have a field on the form which records when the last check was carried out. I would like to keep this field up to date so the latest date appears whever the user view...