requery lookup information

  • Thread starter Thread starter Angi
  • Start date Start date
A

Angi

I have a lookup form that displays information based on what is
selected from an unbound combo box (cboLU).

I've added a cmd button (cmdRemove) to the bottom of the form to
delete (make inactive) the current record. It takes the name out of
cboLU, but it doesn't requery the main information. I end up with a
blank in the combo box, but the form stays filled in.

My current code is:

Me.Inactive = True
Me.Dirty = False
Me.cboLU.Requery
Me.Requery

My form source is:
SELECT tblStudent.*, tblStudent.SdtID FROM tblStudent WHERE
(((tblStudent.SdtID)=[Forms]![frmStudentLU]![cboLU]));

I've tried using Me.SdtID.Requery, but that didn't work either. Any
help would be appreciated. TIA
 
Angi said:
I have a lookup form that displays information based on what is
selected from an unbound combo box (cboLU).

I've added a cmd button (cmdRemove) to the bottom of the form to
delete (make inactive) the current record. It takes the name out of
cboLU, but it doesn't requery the main information. I end up with a
blank in the combo box, but the form stays filled in.

My current code is:

Me.Inactive = True
Me.Dirty = False
Me.cboLU.Requery
Me.Requery

My form source is:
SELECT tblStudent.*, tblStudent.SdtID FROM tblStudent WHERE
(((tblStudent.SdtID)=[Forms]![frmStudentLU]![cboLU]));

I've tried using Me.SdtID.Requery, but that didn't work either. Any
help would be appreciated. TIA
Click to expand...


I assum the rowsource of cboLU excludes inactive records? I think that you
have requeried cboLU but not cleared its value (which, since it is no longer
in the rowsource, doesn't display). Add the line:

Me.cboLU = Null

before you requery the form.
 
I have a lookup form that displays information based on what is
selected from an unbound combo box (cboLU).
Click to expand...
I've added a cmd button (cmdRemove) to the bottom of the form to
delete (make inactive) the current record.  It takes the name out of
cboLU, but it doesn't requery the main information.  I end up with a
blank in the combo box, but the form stays filled in.
Click to expand...
My current code is:
Click to expand...
   Me.Inactive = True
   Me.Dirty = False
   Me.cboLU.Requery
   Me.Requery
Click to expand...
My form source is:
SELECT tblStudent.*, tblStudent.SdtID FROM tblStudent WHERE
(((tblStudent.SdtID)=[Forms]![frmStudentLU]![cboLU]));
Click to expand...
I've tried using Me.SdtID.Requery, but that didn't work either.  Any
help would be appreciated.  TIA
Click to expand...

I assum the rowsource of cboLU excludes inactive records?  I think thatyou
have requeried cboLU but not cleared its value (which, since it is no longer
in the rowsource, doesn't display).  Add the line:

    Me.cboLU = Null

before you requery the form.

--
Dirk Goldgar, MS Access MVPwww.datagnostics.com

(please reply to the newsgroup)- Hide quoted text -

- Show quoted text -
Click to expand...

That was it. Thank you!
 
Back
Top