Search results

Nail on the head there I think Paul... ::the penny drops!:: Thank you!

Again, thanks for the help guys. Two thoughts: 1. I never considered that this could be done with no VBA at all. I guess I need to research how to use paramter queries with subforms? 2. If I do continue down the VBA route and I set the record source of the subform to my sql query within VBA...

Thanks for getting back again Paul. So do I just need to set the record source of the form to equal the sql statement then instead of opening it into a recordset? Here is the full code for what I am trying to do with the subform so far: Private Sub lbx_deliveries_AfterUpdate() Dim...

BUMP! Can anyone help with this please?

Thanks for the previous advice. I now have a continuous sub form within a main form. My question now is: how do I populate the text boxes on my continuous sub form with data held in a recordset from a query. I can't use the Control Source or Record Source in the properties menu because I need...

Yes, each row could have its own selection from the combo box. Thanks, I will look into continuous and subforms - I don't know them.

Hi all, I am going to be designing a user form. I want to run a query and display the resulting recordset on the form. It will be multiple columns of data so was planning to use a listbox. What I then want to be able to do is present the user with a combo box of options corresponding to each...

Thanks for the advice Bob... However, what about when I want to transfer the value selected in the combo box directly into an sql query? The combo box format is set to be a short time but as soon as I move it into my sql query is appears like this: 08:30:00 I need it to be in a time format as...

Hi people, I could do with some help, I have a combo box which holds a list of times which I have entered in it. eg. 08:00, 08:30, 09:00 09:30, 10:00 I have set the format of the combo box to be short time 00:00 However, when I move the value that has been selected in the combo box to...