Recordsource - display problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a bound form which, when the Record Source is hardwired on the
data tab of the form's properties, will display all appropriate
records. However, if I set the Record Source in code eg.
(Me.RecordSource = "myTable"), it only displays the first record.

Any Suggestions?

Martin Dashper
.

Relevant Pages

  • Re: Recordsource - display problem
    ... The fact that, when the Record Source is set in code, only one record ... Record Source property is set to the same table, ... and the data types are correct. ... data tab of the form's properties, will display all appropriate ...
    (microsoft.public.access.formscoding)
  • Re: Access forms
    ... order to be displayed on the form, but the form's record source could easily ... If it lists a table name, then there's no query issue ... the main database window. ... blank because there's no data to display. ...
    (microsoft.public.access.forms)
  • RE: Display information from other tables
    ... Create a query with all of the fields that you want ... and then use that query as the record source for your form. ... You can use a form to display data from a single table or if you want to ... I want to "display" the Division and District information for the record on ...
    (microsoft.public.access.forms)
  • Re: unbound combo box with invisible entries?
    ... though the record source exists, it does not display. ... The dropdown remains blank. ... Have you recently installed Access 2003 Service Pack 3? ...
    (microsoft.public.access.formscoding)
  • Using Search Combo Box after Requery
    ... Form 1 (record source is a table) has a combo box that that is used to search ... then display the recordset works fine. ... If another record is selected the correct recordset is displayed, ... just as when Form 1 was first opened but selecting the new record always ...
    (microsoft.public.access.formscoding)