Search results

I have a form with three cascading combo boxes and data is entered via a subform, the third combo box will only ever have four entries in it max. i can fill the subform in, them requery the form and select another item from the third combo or exit the form. What i want to do is that every time i...

I have the same version thanks Bob fitz for all your help, have a great day.....:D

Bob Fitz where do you find this, is it in the "options", and thanks for the other suggestions Peter

Bob Fitz, I would like to thank you very much for you help and time in helping me with my problems. :D All is working well now Peter

Bob Fitz, Thanks for you reply, that part seems to work but now i get an error message when i try to save the data. I think it may be in my relationship. i have included the error message and the relationship table, and if need be the data base. Hope you can help. many thanks Peter

Thanks guys for your help My scenario is that I have a form named “frmMain” on it has three cascading combo boxes, the first named “cboStation”, the second “cboStaff” and the third is “cboPPE” and a sub form called subfrmMaint to enter the required data Both forms have the “data entry” and...

hope someone can help, I have a form with three cascading combo boxes and a subform, the third combo provides a bound field that joins it to the subform, i use this code on the "on change" event on the third combo box, Private Sub cboPPE_Change() Dim strFilter As String strFilter = "IDPPE = "...

Pbaldy, Thanks for you reply, I have found what is going on but donot why or how to fix it hope you can help. I created two cascading combo boxes, one for “StationName”, “cboStation”the other for “Staff”, “cboStaff” and with txt boxes bounded to them, when I entereddata into “cboStation” the...

Hope some can help me, i have read many cascading threads and tutorials and videos on the subject and still it does not work, My scenario is that I have a form named “frmMain” on it has three cascading combo boxes, the first named “cboStation”, the second “cboStaff” and the third is “cboPPE”...

John , Thanks for all your help, I will have a look at how you did what you did, it looks like a better and even a easer way, once again thank you very much for your time and help. Peter ;)

John, i assume that after I use the cascading combo boxs this would end in a form that will allow me to only enter the data i need. i will have to have a read how to do the cascading combo boxs, thanks very much for your help. Peter

John, Thank you for your reply, I am a fireman, I am trying to develop a program that allows me to record when and what the fireman have done to their personal protective equipment (PPE) either cleaned/ repaired or decomtaminated. I wanted to first filter staff by their station selected by a...

Mr B when the form opens and nothing is selected all is ok, and additions and data entry are set to yes, when you select the conbo box for a name this populates the first subform, and also causes the second subform to be populated with previous data, if you look at the properties for the second...

Mr.B, I know that it will only allow new records, but when i run the form, access changes the data entry property to no, this is what i want to stop, access from changing this property. Peter

I just want them to be able to add new records only, not see, edit or delete other records. Peter

I hope someone can help me, I have a form with a combo box and two subforms, the combo box has a list of names, when one of these is selected the first subform is populated with a list of clothing types that is related to the name selected from the form combo box, when one of the clothing types...

Problem found and fixed. use a query with a nul critera in the record source in the subform this will stop the field from displaying " #name?" in the empty field then try not setting the RecordSource of the SubForm until the AfterUpdate event of the second form ComboBox?

form "2-tblStation" is where the combo box and the subform are, but you need to run the form "2-StartUp" so the combo box in the "2-tblStation" is filtered correctly Peter

vbainet, if you open the attached data base, go to forms, and select the form called "2-StartUp" that is the first form, in the combo box select a town (Gold Coast) and press the "open form combo" button, this inturn will open the second form "2-tblStation" and subforms, this is where i am...

vbainet, Thank you for the trouble you are going through to help me maybe it might be easier if i down load the data base for you to see all. the first form is called startup select a town from the combo box and away you go. Peter :o