using ms access 2000, I have a form(VB) that when it displays a record using the find/replace function, it displays properly however, the record locator at the bottom of the form stays on the previous record messing up any updates.
I'm attaching the form.
Any help is greatly appreciated!!
JOE
Guest
thejoemeister,
How are you using the "find/replace function"?
What are you trying to achieve? If you want to change iformation in records I would use an udate query.
My boss has a form that displays table data. It has a search button that when clicked, it calls the MS Access Find/Replace tool. When a search is performed and a record is displayed, it does not change the record locator so when edits are performed, the changes are applied to the "previous" record and not the current one. I tried uploading the form, but I don't see it anywhere here.
In the meantime I will study up on the update query.
To post the database firstly zip it then attach it.
Let me see you have a form with controls etc and you want to FIND a certain record for say a certain customer. Am I on the right track? If so then you need to use a combo box to look up the record and display it in the form. An update query is to change data in the underlying table.
If this is what you want to do then reply and I will send you a sample db. My way only works if you want to look up set fields.
The db owner created a table for everything that the data entry clerks fill out. Essentially, everyone works out of the same table.
The owner had someone create a form that created different levels of user/groups so that access to the db was regulated. In comes me, the joemeister, and since I know what MS Access is and I have played with it before, I've been tasked with fixing this mess.
The problem is thus:
With the one "Master sales" form, depending on the user, certain fields will be accessible. The way it is supposed to work, when a search is performed an lets say you were at record #5, it "displays" the found record, let's say #10, however, when you click on "Notes" in order to make some notation, the record is #5, the one previous to the search. It's like the record curser is not following properly.
Been working on this for over 3 weeks, so any help is extremely appreciated. The database won't compact to less than 4mb so I'm sending you the "master sales" form. If you need the whole database, please provide an email address that will accept a 4mb file.
Thank you, but I'm not sure where to place this code in the form. Should I bind it to the search button or an additional button? I tried the search button, but to no avail. Thanks!
