Recent content by gingernob

apologies, error in copy/paste; in above 1) should state: "SELECT strTable2.FullName, strTable2.INVIGID, strTable2.DELETED FROM strTable2 WHERE ((([strTable2].[DELETED])=0));

Hi Aceman1 Thanks for that and yes, conceptually all understood and re-created my static table, BUT now what i want to do is: create a TMP[rnd] table and load the rowsource of the listboxes from the tmp table. all the creation side works, just when my unbound form loads and i try to set the...

PERFECT!!!!!!! EXACTLY what i was looking for..really appreciate swift response.

Hi if i have understood your question correctly, this is how i did it, but can not say i am an expert..just it worked for me. ' I chkd for if the field is null first, if it was empty (null) then i passed it the string location of the file via 'sourcedoc Hope this helps. David If...

Hi i have a parent form: frmExams with a subform frmINVIGILATORS The subform represents the contents of a table INVIGACTIVITY. The master field link is via EID field (exam ID) im trying to do a dcount on the afterupdate event of the subform, which does work with the following...

Newbe, I have searched forum but could not find something identical: Have 4 tables: exams invigilators invigactivity invigstatus fields: exams:eid, [plus other not relevant stuff] invigilators: invigID, invigstatusID [plus other not relevant] invigstatus: invigstatusID, invigstatus...