Don't know if I am doing something stupid here
I have a combo box populated by a select distinct query that list all the current used suppliers, first column = refno, second column = supplier name.
a text box is then populated with the value in the first column
this combo box is then on a continuous form bound to a query that shows the current hired equipment, when then user selects a supplier the form is requery(ed) and only the relevant records for that supplier are shown for editing. This is done by having the underlying select query has a field whose parameters are from the text box populated earlier by the first column in the combo box (hope this makes sense)
right now to the problem
If the form is set to allow addtions all works fine but I get a blank row at the bottom which I don't want, if it is set to "no additions" the text box with the value from the combo box is blank and therefore the select query returns no records.
I am now usimg access 2010 after using 2003 for numerous years and consider myself a comptent access user and I am sure I have used this technique in the past with no problems - has anyone any ideas
thanks
Dean
I have a combo box populated by a select distinct query that list all the current used suppliers, first column = refno, second column = supplier name.
a text box is then populated with the value in the first column
this combo box is then on a continuous form bound to a query that shows the current hired equipment, when then user selects a supplier the form is requery(ed) and only the relevant records for that supplier are shown for editing. This is done by having the underlying select query has a field whose parameters are from the text box populated earlier by the first column in the combo box (hope this makes sense)
right now to the problem
If the form is set to allow addtions all works fine but I get a blank row at the bottom which I don't want, if it is set to "no additions" the text box with the value from the combo box is blank and therefore the select query returns no records.
I am now usimg access 2010 after using 2003 for numerous years and consider myself a comptent access user and I am sure I have used this technique in the past with no problems - has anyone any ideas
thanks
Dean
