Recent content by shutzy

i am trying top create a stock take form. the form is now set up so each time an item is scanned a new record is created in the tblStockUpdate. i ow need to create an update query that updates tblItems with the correct quantities. the relational data will be the barcode and is unique to each...

i have managed to make it show the records with the after change event on txtSubID to requery the subform.

thank you for that. but what is it meant to do exactly. there are no records appearing in the -TreatmentSubform

have you not opened the attachment? frmWaitingList-Subform Has ID and frmWaitingList-Treatmentsubform has tblWaitingListID. sorry i wrote the last post incorrectly

tblWaitingList.ID & tblWaitingListTreatments.tblWaitingListID the tblWaitingListID maybe should be WaitingListID

in the treatment subform master field i have put Forms!frmWaitingList!frmWaitingList-Subform!ID in the child field i have put tblWaitingListID is this right. is it even within the correct form. this is very new ground for me. i tried changing the source object but that changes the whole...

sorry im braindead. try checking design view. ha ha

i have read it and i dont seem to be able to find the subform linker. is it because i created a form then draged it in instead of creating a subform within the main form

what would this do. or is it a big suprise?

i have attempted what you suggested vba. i have created 2 subforms. both continuous. i have created a buttton on the waiting list record to show treatments within that record on the 2nd subform. just to see if it works really. i have attached the relevant tables and forms and welcome any...

sounds like it would do the trick but im not sure the data would display easily. its for a waiting list. so we could do with quick viewing and the girls are beauty therapists. not exactly pc friendly and they can make alot of mistakes. one possibility would be to have the continuous for...

i have an audit trail. im not sure if i did it correctly but i created an audit tbl. then on every click of every button i put some code in. to append data to the audit tbl. i did create a log in screen first though. this is recorded too. its quite a long way to go about it depending on how big...

i know all you guys out there are gonna tell me this cant be done for various reasons however i had this image in my head of what i wanted to do and what it would look like. however it cant be done via the subform route so i will need some suggestions. what i have is a one to many table format...

i wasnt trying to argue. i was just trying to find the most definitive route of getting the unique record. there are variables that can happen that would cause an error in this. because it is not a unique record. yes those 3 factors date time employeeID can narrow the results down to one record...

the date and time are not unique to them. some days we have 4 employees and all could have something in at the same time. i really could do with OrderID to be able to have the unique relationship.