Navigation bar won't show more than one record

[NettieJob]

Hi all. I have scoured the globe trying to find this answer, but I have failed, so now I'm turning to the experts. I've figured out a way, thanks to many forums, how to create a form that does a search by customer name or phone number, then you can double click the result you want and it'll open up another form and fill in all customer info for you. The problem is that when I do select a customer, it does open up the other form for me, but it gives me an error that says "No current record."

I figured out why... I think. The navigation bar on the second form that opens always says record 1 of 1, unless I create more fictitious customers, then it goes to record 2 of 2 etc. As soon as I close the form, it forgets all the records that have been entered, even though they're in the tables.

How can I get the navigation bar on the form to allow me to scroll through all records?

Thanks a bunch in advance. It's gotta be something stupid I'm not seeing.

One more thing... I've noticed that most solutions in this forum require VBA. Should I just bite the bullet and learn it or can I do most everything from the Access interface?

 

[Norie]

I thought you only wanted to display one record in the 2nd form?

How exactly is the that form being populated?

All you should really need are 2 forms.

One a list of all the customers and another for the full details of the customers.

Both would display multiple records when opened on their own.

When you open the full details form from the list of customers you should only see the relevant record.

That's the usual way to deal with this sort of thing in Access and you can do the basics through the wizards that are available for controls like command buttons.

Ideally there would be some sort of ID involved, normally the primary key from the table(s) the data comes from.

You use that ID to link the 2 forms (and tables, if you have more than one).

If you create the customer list form and add a button in the detail section (where the fields are) you should get a wizard.

This will ask you to choose what will happen when the button is clicked.

One of the choices is to open another form, which is the one you probably want.

The next option will be which form to open, in this case you probably want customer detail form.

Then you'll be asked if you want to open that form to a specific record.

If you select Yes then Access will prompt you for a field to link the 2 forms, and if the have a common field, eg ID, it will suggest that field, so accept it.

Finally you can name the button and that's it.

Now you will have a button for each record on your customer list form that when clicked will open the details form at the associated record.

Hope that's not garbled rubbish - it's kind of from memory.

I used to use these wizards a lot and still do but not so much.

They're great for getting the basics for this sort of thing though.

 

[NettieJob]

I do have two forms. The first form has a text box that I can type any part of a name or phone number and it will narrow down all the customers I have listed in the list box below it. Then I can double click the selection I need and it should open a different form and fill in all the customer details. I have to do it this way because I can't spend time looking through a list of customers as a customer is breathing down my neck. =)

Anyway, that part of the whole thing works flawlessly. I've made a few forms before and they've always had that navigation bar at the bottom that you could scroll through all the records you've entered in the past. I do have that bar, but when I first open the form, it only shows 1 of 1 record. If I entered a bunch of data and created several more records, the navigation bar will display the additional records (like Record: 1 of 10), and I can open the original search form and any of the customers I just entered will be able to be selected and it'll work perfectly. As soon as the customer entry form is closed, the navigation bar with go back to Record: 1 of 1 even though my customer table is being populated.

I'd kill to be able to post pictures.

 

[xenou]

To repeat Norie's first questions...

I thought you only wanted to display one record in the 2nd form?

How exactly is the that form being populated?

I also thought from you explanation that you only wanted the second form to display detail information from the one record on the main form.

And as far as why it displays only one or only ten records ... that has to do with how it is being populated.

 

[NettieJob]

I'm sorry if I'm being confusing. This has been driving me nuts.

I do want to display only one record on the second form, but if I can't get the navigation bar to recognize that I have more than one record in my database, the first form will never pull up any information about the selected customer that was clicked in the first form. Instead, I just get the "No current record." error box.

 

[Norie]

Sorry, I think I might have confused things.

But I'm a bit confused too.

Would a form with a list of customers and perhaps a few other pieces of data to help identify them not be of use?

It wouldn't be too difficult to add some sort of search/filter capabilities to a form like that.

Each customer record in the list would have a command button that opened up the details form for that customer and that customer alone.

 

[xenou]

then you can double click the result you want and it'll open up another form and fill in all customer info for you

So when you double click the second form just have it filtered to the same record.

It would be easier if the second form is modal so all you have to do is control the open event. Otherwise, you'll probably need to code the forms to be in synchronization. I don't think the user should be allowed to scroll in the second form anyway - its purpose is to show details of the record on the main form, not to be another form that works on its own for navigating records.

A simpler approach if you have room on the main form would be to show the details in a subform, but this takes up more room of course (and if the details are only needed sometimes then a second form is a good way to provide the "option" to see more).

Note: Re visual basic, you don't need it to create a decent Access application. I think it's worth learning as there's plenty of neat things you can do with visual basic. I'm a little guilty of forgetting that you don't actually need to write your own visual basic code to do some of the same things using macros and access wizards - access macros offer a set of useful tools to serve many common purposes.

 

[boblarson]

I'm sorry if I'm being confusing. This has been driving me nuts.

I do want to display only one record on the second form, but if I can't get the navigation bar to recognize that I have more than one record in my database, the first form will never pull up any information about the selected customer that was clicked in the first form. Instead, I just get the "No current record." error box.

Sounds like you have that second form's DATA ENTRY property set to YES and when it opens it opens to no record so there would be no current record to match what you are trying to open it to. Make sure its DATA Entry property is set to NO.

 

[NettieJob]

Sounds like you have that second form's DATA ENTRY property set to YES and when it opens it opens to no record so there would be no current record to match what you are trying to open it to. Make sure its DATA Entry property is set to NO.

OMG! That did it! Thank you!!! Now I can go on!