lost combo box datasheet display on form

[laurachigro]

Simple question..totally new to access...haven't used any db since dbase3. Created a combo fox form but somehow the datasheet view is only showing the current record, whereas I saw it earlier with all the records from my table. I have accidentally done something in properties, but can't figure it out..

 

[vbaInet]

Under the DATA tab have a look at the "Filter On Load" property. Set it to NO. I'm talking about your FORM's property sheet.

Welcome to AWF by the way

 

[vbaInet]

Please post your replies on here instead of the Visitor's area of my page. It makes it easier for others to know how the thread is progressing and how they can contribute.

You said you changed something to do with the Properties so I was assuming you knew what a PROPERTIES SHEET is. If you don't just Google it.

 

[laurachigro]

oops..meant split form not combo box.

 

[vbaInet]

Alright, so in the Properties Sheet of your split form, follow the instructions on my post #2.

 

[laurachigro]

that didn't help...thanks anyway..i just want all of the records in my table to be viewed in the datasheet portion of the splitform..not just the current record. I have obviously changed something in the properties that I shouldn't have...but not sure which one.

 

[vbaInet]

Post your db and I'll have a look.