Recent content by Dragnog

Sorry I need you to be more specific. I am assuming that I need to put something into the criteria of the query in square brackets, creating something like a variable - how do you then associate this with the text box? Do you just put in the text box: =[variable_name] Is that correct? Daniel

Hello All, I am wondering if it is possible to set a variable for a report as a condition for that report. To give you an example, if I had a report of all the staff at the company and wanted to search for one particular staff member, entering their name in a text box on a form, how would I be...

Thanks for the info Wayne. I thought that this was probably the case, I just wish I was allowed to the development for this in VB! I think I will have to use a different approach.

Hello all, I was just wondering if someone knew if an array of controls was created on a continuous form and if so can you address these indvidually? If you have an unbound combo box on a continuous form, when you select the value for one instance it changes the value for all of them. I want to...

Thank you for the information. On a slightly different tack, but basically to do with the same thing, as I have this combo box unbound how would I get it to show the value of the the name in the drop down box? For example once you have selected someone from the list all of the names change to...

I have a database that has a relationship between three tables called Staff StaffEscalation and Escalation. The relationship is: Staff StaffEscalation StaffID(1)--------(many)StaffID StaffEscalation Escalation EscalID(many)---------(1)EscalID In the Staff table I have the Staff...

Thanks, this information helped me out. Just as an aside you don't hapen to know how to force a new record to be created? I creat a new record using my form and I assumed at that stage a new id (an autonumber) would have been created but this does not seem to be the case.

I am having the same problem I have been trying to do something similar. As far as I understand from messing around with the combo box when you have a selection from a table this is completly independant of the table even when it is bound to a field. So what I am assuming is that you have to...