Refreshing problem

[Beany]

Ok, i have an add form that allows me to add site details......
on a different form i have a combobox from which i select a site name and it brings up the details.....

once ive added new details... i need to close the database down and go back into it for it to appear in the combobox??? ergghhh :(

when i add it from the add form, why cant it straight away show in the combobox???

ive added some requeries to my code below. (please note there are a few comboboxes on that form)

Combo2 searches sites by name and only shows live or pending
Combo22 searches sites by telephone numbers
Combo3 searches sites by names and only shows cancelled lines

WHAT SHALL I DO??? CAN SOMEONE LOOK AT MY CODE???

Private Sub add_Click()
 Dim strSQL As String
 DoCmd.SetWarnings False
 Dim strmsg
 strmsg = "Are you sure you want to add " & site & " to the table?"
 
If MsgBox(strmsg, vbYesNo) = vbYes Then
 
 strSQL = "INSERT INTO tab_data ([product], [provider], [site], [tel], [address_1], [address_2], [address_3], [postcode], [ip], [username], [password], [use], [type], [status], [notes], [line_provider], [line_status]) VALUES ('" & Me.Combo26 & "','" & Me.provider & "','" & Me.site & "','" & Me.tel & "','" & Me.address_1 & "','" & Me.address_2 & "','" & Me.address_3 & "','" & Me.postcode & "','" & Me.ip & "', '" & Me.username & "', '" & Me.password & "','" & Me.use & "','" & Me.Combo50 & "','" & Me.status & "','" & Me.notes & "','" & Me.line_provider & "','" & Me.line_status & "')"
 
''Debug.Print strSQL
[Forms]![Form1]![Combo2].Requery
[Forms]![Form1]![Combo22].Requery
[Forms]![Form1]![Combo3].Requery
 DoCmd.RunSQL strSQL
 DoCmd.SetWarnings True
 End If
 
 
End Sub

[Rabbit]

The problem is that your SQL Insert is after your requeries. What's happening is it requeries and then it inserts. Move your insert up.