Recent content by Emma35

Thanks everyone for the great suggestions as usual....i appreciate you giving your time for me Em x

Hi Pat....yes it's the very last record added to the table. I realise that when the operators change the new person will get the previous operator's name but that's ok they just have to change it once

Cheers plog i got that method to work also. Now i've got two options for the future

Thanks arnel that code works fine

I needed a command button to populate three txt boxes with the very last record added to the table. When a new operator takes over, they change the txt box to their own name, after which the button will add their name to the next record

Cheers....looks like i've been pretty fortunate up to now. I've tried setting up a query and sorting the autonumber field to Descending but it still doesn't work ? How do i get the max ID number directly from the table ? Thanks

Hi All, I've been using some code in the OnClick event of a command button to make the last entered record appear in the text boxes of a new record. The txt boxes record the operators name and two other items and rather than getting them to keep selecting the same things they can just press...

Pat i understand what you're saying but i'm just not 100% clear about how removing the child table would fix the issue. What am i looking for when i open the query ? Thank you for your help

Thanks Mark.....i redesigned the report to omit the subreport and grouped the data as you recommended. Works perfect. Thanks a lot for the help.

Sorry guys i sometimes forget you're actually human :) I've attached a smaller version of the database. To add records you use the frmClothingIssue. To search use frmSearchOptions1 and the report in question is rptSearchResults. Thanks for the help all

Hi All......i'm back a bit sooner than i thought I'm updating a database which records the dispensing of safety equipment to employees. I have a main form which records the person's name, ID number etc and then a subform where you use combo boxes to list the equipment given to that person. My...

Thanks DBguy the first option worked fine. Got it going now. Gasman.....yes i was using the subform name and not the control. All ok now thanks

Below is the closest one i can find in there to my problem but it doesn't work ? Me!Subform1.Form!ControlName

Hi Everyone.....i have a quick question regarding cascading combos. I have two of these on a subform and i'm trying to make a selection in the first which controls what's visible in the second. I have the Rowsource of the second combo set as below but i think i need to reference the parent form...

Well it looks like you were right to ask a 'silly' question because i've just worked out the problem. The cell where i was entering the formula was (for some reason) formatted as text. Honestly i never even thought of checking something so basic. My fault for not checking the obvious things...