Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Forms & Form designer
Nadya. I've done all that. That's why I'm asking how to get them in the order that I want. Maybe I want the 3rd field in the first column, not include the 6th field and then who knows what else. I have done all the things as you have said and that's why I posted this. Because some syntax or something is not right. The table alias is available. It is full of records. I have all the columns control source set to the appropriate field. Is there something wrong wiht the syntax of the RecordSource? What else can I look for that would cause the grid not to populate? I woudn't have posted the information I did if I thought it worked.
>>It's actually a table, but I've always used Alias. Never had to use Table before that I recall. If the table is open, isn't that the Alias?
>>
>>Update: Didn't work with "Table" either. I have done this before, can someone just tell me how to get the fields in the correct order in the grid?
>>
>>And I do have the ControlSource for each column set to the appropriate field.
>>
>
>In the grid RecordSource specify the name of your table. It should be opened in the form's Load (or DE), so available when grid initializes.
>
>Specify the ColumnCount property to the number of the desired columns. Specify each column's controlSource to 'myTable.myField' (right click on your grid to Edit). Adjust widths and make sure your column headers are set correctly.
>
>That's it. Of course, it could be done through grid builders (and the custom builders, one example of them I gave you).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only