Refreshing

[Jbajin]

I can't figure out how after making an SQL statement to get the results back to the main form. It looks like it searches, finds the record and then the form disappears and the new information doesn't appear. Any help would be great.

[Altecjjf]

Did you try the REFRESH staement.
Updates the objects in a collection to reflect the current database's schema.

Syntax

collection.Refresh

The collection placeholder is an object variable that represents a persistent collection.

[JHausmann]

Can you post the code?

[Jbajin]

here is the Code.

Private Sub SearchButton_Click()
Dim fieldStr As String
Dim searchStr As String
searchStr = Form1.SearchString
fieldStr = Form1.ComboSelect.Text


frmMain.Gold.RecordSource = "SELECT * FROM [GOLD] WHERE " &
"[" & fieldStr & "] = '" & searchStr & _
"'"

frmMain.Gold.Refresh
Form1.Hide
End Sub



Joe

[Jbajin]

Yeah Gold is my data control for the program. It holds our database.

[JHausmann]

Sadly, data controls are not my forte. Is control being set to frmmain once you hide from1? Does a formmain.refresh (or formmain.show) help?

[Edited by JHausmann on 06-29-2000 at 03:06 PM]

[Jimmer]

What are you using to show the retrieved data in, a datagrid, text boxes, etc???
You may need to refresh these connections to the data control. If it is a grid, you could try rebinding the grid and this might work.