Hi. I have a sub form attached to a main form. The record source of the subform is a table. The subform is formatted to datasheet view. Ok. Here's what I am trying to do. The users chooses a value on the main form from a combo box. After the event occurs I want to add records from one table to the table in which is the record source for my subform. I can do that just fine but when I requery the subform record the data does not show up in the subform. My sub is below.
Any thoughts on what the heck is going on?
Private Sub Update_sfrmEstimateDetails()
On Error GoTo Err_Update_sfrmEst_Details
Dim intNumRecds As Integer
intNumRecds = 0
intNumRecds = Add_ClaimDetailstoTempTbl <-- function to add records from one table to sub form record source table.
If intNumRecds > 0 Then ' Verify records are present
MsgBox "There was a problem appending the data to the temp table. Contact your administrator.", vbCritical, "CCS Estimator - Loss Location"