requerying subform

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alienz
    #1

    requerying subform

    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_Before Update(Cancel As Integer)

    End Sub

    Private Sub PONumber_AfterU pdate()
    Me.PO_Item.Requ ery
    End Sub


    Any human thoughts appreciated.
    Tags: None
    • Reggie
      #2
      Re: requerying subform

      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

      https://www.smittysinet.com

      ----------
      "Alienz" <kstetka@yahoo. com> wrote in message
      news:58e54da4.0 405181159.614ba 471@posting.goo gle.com...[color=blue]
      > 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_Before Update(Cancel As Integer)
      >
      > End Sub
      >
      > Private Sub PONumber_AfterU pdate()
      > Me.PO_Item.Requ ery
      > End Sub
      >
      >
      > Any human thoughts appreciated.[/color]


        Comment

        Previous template Next
        Working...