Search results

jfgambit: It is just the way that i had it set up in my database that i took the example from.

Thanks Cheers for that FoFa. The problem was that the combo was bound. Have replaced it with an unbound one set to make the other one invisible. Works fine now. Steve

sorry my mistake ... i have had a look and it does work just as fizzio says earlier. here is an exaple.

It kinda works I have it sort of working ... it recognises that it has found the matching record but then i get an error .. see bottom the basic code i am using is Private Sub cboServiceSelect_AfterUpdate() Dim unit Dim service unit = Me.txtNameOfUnit service = Me.services...

Have you got it set to requery the form on the afterupdate of your combo box?

try Private Sub Form_Load() Dim rst As Recordset Set rst = Me.RecordsetClone If rst.EOF Then 'MsgBox "Your Message Here.", vbOKCancel If MsgBox("There are no forms matching this criteria", vbOKOnly, "No forms") = 1 Then docmd.Close acForm,"formname" End If End If End Sub hope that helps Steve

I can't seem to get the wizard to create the code for a lookup using a combo box. I am sure that the problem is because the combo box is bound. HELP!!! Steve

i can do the dcount bit but my problems is how to make it go to the record Steve

I will try and explain the situation: 1. I have a main form that the user inputs details .. all works fine 2. The user clicks a button to add / edit / view (depending on the selection) details in a linked form. 3. Viewing the details is fine. There is a box at the top that is populated fron the...

I use this: Set the tag property of the fields visibility you want to change to HideIt. Create a module and add this code: Function HideIt(FormName As String) ' This procedure will reverse the visability of any ' controls identified with Tag = "HideIt" Dim F As Form, x As Integer Set F...

Thanks Cheers Tim & Mile .. That is exactly what i was looking for.

I can now get the check boxes to select and unselect ... just need a way of getting the checkboxes to select the relevent part in the multi select list box. btw the check boxes are named chk0 , chk1 ... chk29 if that helps. chk0 refers to row 0 in the list box

Help. I am having problems with a milti select list box. I have a series of hidden check boxes that i need to select as each relevent selection in the listbox is highlighted. (After update of the list box) Also as i come into the record i need to do the reverse. (Forms current event) ie...

Cheers Tim Works like a charm

Hi guys, Sorry to be having a stupid day today but... I have a form with loads of chk boxes on it and a command button to update. What i need it to do is when the command button is clicked it loops around all of the chkboxes and adds the tag into a variable for putting into a text box. I...

Thank you Cheers Mile-O-Phile knew that it was something daft.

Help!! I have just created a query and it doesn't work. Basically to give you the background... I have a text box with things seperated by commas. I would like to run a search using a combobox on a search form. That side is fine the problem is that i can't get the query to work. It looks...

I am sure that i this is a morning problem but, How do i clear a multi select list box as i move on to the next record?? Also is there a way of keeping the selection. ie it is saved into a text box as it is added but i want the list box to pick up the selection when i get back to the record...

Thanks Cheers Fizzio it works like a charm. Had to change it a little but thanks for the prod in the right direction. Private Sub lst1_AfterUpdate() Dim ISel As Integer, I As Integer Dim listvalues listvalues = "" ISel = 0 With lst1 For I = 0 To .ListCount - 1 If .Selected(I) Then listvalues...

Is this possible ??? If not is any of it possible? Thanks Steve