By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

requerying subform

P: n/a
Alien hello to whoever is reading today. Ill try to explain this as
simply as possible its just a weird thing thats happening here in
Access 2000 subforms..

I think something small is out of place. If you have a sec to share
some human thoughts it would be much appreciated!!! I created a
subform that is linked to a main form. I locked all of the combo
boxes in the subform and basically my goal is to have the subform
display whatever its linked to from the main form.
I did this by linking a child field. So, everyting works now.. but
theres a slight anomaly... heres what happens:
---
entering data into main form:

enter value1- no change in subform
enter another value2- data for value1 appears!
enter another value2- data for value2!!

and everything is smooth after that...
--------
heres the code that is attached to the combo box in the main forum

Option Compare Database

Private Sub PONumber_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub PONumber_AfterUpdate()
Me.PO_Item.Requery
End Sub
Any human thoughts appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I assume the your master/child link is based on the combo boxes bound column
on your main form. After you select a value in your combo box on your main
form, you want the records on your subform, where the linked fields match,
to show on your subform. If so, make sure the Control Wizard on the tool
bar is selected. Now add a combo box to your main form and follow the
wizard.

--
Reggie

www.smittysinet.com
----------
"Alienz" <ks*****@yahoo.com> wrote in message
news:58**************************@posting.google.c om...
Alien hello to whoever is reading today. Ill try to explain this as
simply as possible its just a weird thing thats happening here in
Access 2000 subforms..

I think something small is out of place. If you have a sec to share
some human thoughts it would be much appreciated!!! I created a
subform that is linked to a main form. I locked all of the combo
boxes in the subform and basically my goal is to have the subform
display whatever its linked to from the main form.
I did this by linking a child field. So, everyting works now.. but
theres a slight anomaly... heres what happens:
---
entering data into main form:

enter value1- no change in subform
enter another value2- data for value1 appears!
enter another value2- data for value2!!

and everything is smooth after that...
--------
heres the code that is attached to the combo box in the main forum

Option Compare Database

Private Sub PONumber_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub PONumber_AfterUpdate()
Me.PO_Item.Requery
End Sub
Any human thoughts appreciated.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.