Hi all,

Thankgod I found this website as I have been desperate to get my database up and running. I've been looking all over for Access help.. now i've finnaly found it - great!

Anyway, the database is about 90% there, except for one form I am continuously having trouble with to operate correctly. Its a small pizza store database, comprising of 10 customers.

The problem with the database has got to do with browsing within the form, through the customer orders. Basically, I was curious if someone can lend a hand as I am sure it would not take long to fix the problem (I think its got to do with the relationships.. not sure though) as I could send over the database via ICQ (20691868) or email (bradcohen@optushome.com.au).

I've been doing Access for a few months now, so you could say im only very average still.. that's why I think if someone who's been doing it for a while now maybe able to knock over this problem for me.

Hope to hear from someone soon..

Thanks from downunder!

Cheers,

Brad,

How exactly is your form behaving? Please provide more detail.

edtab

It's quite hard to explain, Jon. That is why I wanted to send the database over - its only a very small one.

I'll try a bit. Ok, I have a pull down menu to select from and then fields below it.. when i click on the 'Next Order' button, the fields below don't change, or if I select them from the pull down menu. I think its a little problem, but is having a big effect, so i seriously need a little help .. Im sure it is just some easy little thing to fix, but I cant figure it out! :-(

It sounds like you want your form to go to a record based on what you pick from your combo box list of customers.

Quick solution: Delete the combo box and reform it. Make sure the wizards are on. When the combo box wizard comes up, pick the third option, 'Find a record based on the selection..'

Longer answer: Search the archives for the code that does this same thing. You may have hit cancel when your combo box was forming and so it didn't finish the code you're expecting to be in the AfterUpdate event.

Good luck,
David R

Hi David,

I've tried, and it is not working.

Is it possible to have more than one table to a form? because that is what I am trying to do.

In the form I am trying to fix, when your click next record, it takes about 5 or 6 clicks until the fields update.. that is the problem and I am STILL unable to fix it :/

Maybe its possible to send you the database (its only small) to your email to have a look at because I am quite urgent to get this worked so I can have a better look at it.

Thanks.

1) You can base a form on a query which connects related tables, yes. Connecting unrelated tables can have unexpected (i.e. wrong) effects. If you join them carefully the resulting query is usually updateable (Access help has an explanation of when a query is updateable and when it isn't).

2) Is this the standard Access record navigation button, or something you created? If it's your own creating, try turning on the Record Navigators temporarily and see if they work correctly. Also you can post the code behind your record navigation buttons so someone can perhaps spot it.

3) Sorry I am too swamped this Monday to graze anyone else's databases. Hopefully me bumping this to Today's Topics will let someone else see it.

Good luck,
David R

*bumps thread to the top*

last time before I give up on this form...

Is anyone willing to spare about 10 minutes just to look and correct my database? I've just about pull all my hair out and continue to have no luck... someone.... stop me from going bold here! help!