record selectors on a form

[LOUISBUHAGIAR54]

Hi everyone,

I am working on a form which displays data one record at a time one field over another. These fields are bound to the recordsource of the form.

I have an unbound textbox on the form. I am using this to find records to be displayed on the form, depending on string entries which I make in the unbound textbox. This is fairly standard and the vba code is functioning quite well.

I have removed the record selectors from the form. I am having the following problems:

1. When I try to make the record selectors appear again on the form, by marking the record selector option to yes on the format column of the properties, I am not managing to make them appear. Quite strange. There must be a reason which I am not conscious of.

2. Since on occassion there may be two or even more records that match the string which I am putting in the unbound textbox I will need the record selectors appear so that I can view all the possible fits. How can I make the record selectors appear and disapper using vba ?

Would appreciate if someone knows how to do this and leads me a bit so that I can get the hang of it.

I would like to edit this entry. Just to be sure the record selectors which I am referring to is the small control box which appears at the foot of the form, showing the number of records and a mechanism like< > so that one can move from one record to the other and to both ends.

Many thanks to everyone.


LouisB.

 

[pbaldy]

I believe you're referring to navigation buttons, not record selectors (the gray bar to the left of a record).

 

[LOUISBUHAGIAR54]

I am referring to the selectors at the foot of the form that show the number of records and the movement buttons like < > that move from one record to the next or to the previous, to one end or to the other. Am I naming them correctly ? ??

 

[pbaldy]

I didn't say that very well. What you're referring to are the navigation buttons. The record selectors are the gray bars to the left of a record.

 

[LOUISBUHAGIAR54]

Yes it is the navigation button I was referring to. In fact I have managed to make them appear from the format column on the property section.

Now I would like to make them appear and disappear using vba code. Can it be done ?


many thanks.


LouisB

 

[pbaldy]

I've never tried, but VBA help says they can be set, so give it a try. I suspect it would look like:

Me.RecordSelectors = True

 

[LOUISBUHAGIAR54]

Actually now I have got my code to function as I planned. The bit of code that I was looking for is the following;

Forms.FrmClients.NavigationButtons = True

I had to do this rather than

Me.NavigationButtons = True as the command button lies on another form opened in dialog mode.


LouisB.

 

[pbaldy]

Glad you got it sorted out, even though I typo-ed RecordSelectors instead of NavigationButtons. :banghead: