tab cntl requery

G

Guest

Hello,
I am working with an Access 2002 application that someone else created.
I have a tab in a tab control that allows user to enter values to a Grade
table. The next tab has a drop down box that uses an sql statement to pull
the values of the grade table. The problem I am having is that when a user
enter's values in the grade table, it is not populating in the drop down box
until the form is closed and reloaded. I have tried
Private Sub TabCtl1_Change()
Me.Requery
End Sub

'the tab where user enters grade is named "Grade", with the form named "frm
tblGrade Lookup", record source is tblGrade.

'the tab where the user assigned students to grade is "Class Schedules" with
the form named "frm Class". The drop down box to display available grades is
named "Class Grade" with it's row source being "SELECT tblGrade.Grade,
tblGrade.Age FROM tblGrade ORDER BY tblGrade.Age; "


I have also tried putting requery events in various ON CLICK events, but
can't seem to get them to fire correctly. It seems that all of the data for
all of the tabs/forms is obtained when the main form opens.

Can someone please help me to properly requery so the combo box pull in data
that was entered in the Grade tab page?

Thank you for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top