list box

  • Thread starter Thread starter maan via AccessMonster.com
  • Start date Start date
M

maan via AccessMonster.com

i am having a problem in putting my newly added data in the list box. my list
box does not show on the first column the 1st data that i have entered. i
have a command button to add my data in the list box and i am using this code:

DoCmd.OpenQuery "new_SY"
Me.cmborgsname1.Value = Null
Me.Active.Value = Null
Me.SchoolYear.Value = Null
Me.listactiveorgs.Requery

and the codes for my list box is:
Me.Orgsname.Value = Forms!Form1!listactiveorgs.Column (0)
Me.Active.Value = Forms!Form1!listactiveorgs.Column (1)
Me.SchoolYear.Value = Forms!Form1!listactiveorgs.Column (2)

my list box does not show the orgs name. what went wrong?
thanks!
 
Hi,
let's look at the line DoCmd.OpenQuery "new_SY"
When a form is open, it is very unusual to open a query.

I can't see your form, so this a guess.
Instead of DoCmd.OpenQuery "new_SY"
-- in design view
--select the listbox
--on the property dialog | Data tab
--next to Row Source
--type in "new_SY"

Now delete the line DoCmd.OpenQuery "new_SY"
Save and close the form, run the form.

What is the recordsource of the form?

Jeanette Cunningham
 
Back
Top