Record set does not show on the form 1

[Junkie88]

I have a form whose control source is a query which pulls records from a table based on certain parameters. For some reason, the records do not show up. I checked the query and it does show all the relevant records from the table.

 

[boblarson]

Are you sure that the controls are bound to the fields in the query?

Bob Larson, Access MVP

http://www.btabdevelopment.com

 

[jamaarneen]

Hi Junkie88,

Or, you should check if your form's 'DataEntry' property is set to yes. If so, you should change it to 'DataEntry' = No.

Ja

 

[Junkie88]

the controls are properly bound to the query fields.

setting the dataentry to no is showing me the first record, but the next button on the form does not show me the next record. here is the code that i am using to move to next record. (i need to create my own next button for some reasons)

If Me.Recordset.RecordCount = Me.CurrentRecord Then
GoTo Err_cmdNext_Click
Else
DoCmd.GoToRecord , , acNext
End If

 

[jamaarneen]

Hi again,

maybe you should check if the 'Cycle' property is set to 'Current record', if so, make it to 'All Records'. (it's onder the 'Other' tab)

Ja

 

[Junkie88]

cycle property is set to all records. the default record move button does show me all the records. but i want to see all of them with my own move to next record button which is not working.

 

[jamaarneen]

Maybe try this:

DoCmd.GoToRecord [b]acDataForm, [i]"FormName"[/i][/b], acNext

 

[Junkie88]

actually, i found the mistake. it ad something to do with the code i had written before moving to next record. but i think that setting data entry to no was very crucial.