Form/SQL

[Rick West]

I am running the following code in a form. It fires on the lost focus event of the field called "PNAdd" and is supposed to grab and retain "Part Description". It does not work, can you see anything wrong with this code?



Private Sub PNAdd_LostFocus()
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim strOpenArgs As String

Set dbs = CurrentDb
strOpenArgs = Me![PNAdd]

strSQL = "SELECT [Part Description] from T_PartsMaster WHERE PN = '" & strOpenArgs & "'"

Set rst = dbs.OpenRecordset(strSQL)

rst.MoveFirst

'strV = rst![Part Description]
'Form_F_PNAdd.Description = strVDesc
Description = rst![Part Description]
rst.Close
dbs.Close
End Sub

[pbaldy]

Define "does not work"; error? If so, what's the error and on what line? The MoveFirst line is not necessary and will throw an error if the recordset doesn't return any records.

[SteveH2508]

What is Description in the line Description = rst![Part Description]?

Is it a variable, a text box or what?

[Rick West]

It's just an attribute from the T_PartsMaster, like this:

PN ,,,,,,,,,,,,,,,Description
L77-1225,,,,,,,Bracket

Sorry I had to use commas to keep these separated, they are 2 different fields in the table. PN is keyed.

[Rick West]

I have it working - somewhat. yeah! BUT as in all things, something else is broken now - the underlying form will not refresh with the new data unless I go to form design and back.

What's the trick to get a form to requery itself when it gets focus again?

[pbaldy]

Try

Me.Requery

[Rick West]

Tried it in several different places - nada.

[TheShabz]

try following Me.Requery with Me.Refresh?

[SteveH2508]

Have you saved the record before returning to the underlying form?

[Rick West]

The second form allows data to enter directly into the table, I was unaware that it needed to be saved afterwards.

I thought it was automatically "saved?"

[SteveH2508]

The second form allows data to enter directly into the table, I was unaware that it needed to be saved afterwards.

I thought it was automatically "saved?"

It would save when you move to another record on the same form - switching between forms (without closing the first one) would not save the record (I don't think).

Is the textbox bound to 'Description' also called 'Description'? This might cause a problem.