Button from subform opens wrong record on other form

[aian]

It's Access 2003 but the file is Access 2000.

Here's a link of the same DB converted to 2003 version:

http://www.iliasfragiskatos.gr/irene2003.zip

 

[RuralGuy]

Same problem. Is there any chance you have applied Office SP3? If so then you need to apply the HotFix for the problems that SP3 caused.
Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
...Meanwhile, I'll just proceed without the benefit of your db.

 

[aian]

No, I don't have SP3 installed. And thanks for your patience, I can only imagine how difficult it must be to troubleshoot something in a foreign language...

 

[RuralGuy]

Don't install SP3. Wait for SP4. You are going to want the Charges form to be bound to a generic query that returns all of your records. With the OpenForm command you can apply a filter that will limit the recordset. You need to get the Charges form working properly first. Leave the NavButtons turned on so you can move around in the recordset. You can turn them off later when you get everything working.

 

[aian]

Look, I think we can solve this another way.

The only reason for this form's (CHARGES) existence is to store some charges (well, obviously...) in a table. What I could live with happily is to create a simple form that would store multiple purchases of the same client for the same date. That's all. I don't care if they are bound to any other tables or not, as long as I can have combo boxes from where I can select client's full name (from the query that takes FirstName and LastName and combines them), their client_id and products' names/id's.

Imagine the form I showed you in the screenshot above, with a simple subform that would allow the possibility of adding products and their prices. Mind you that the prices aren't always the same and change in random order so I don't even need a "pricelist" table, the user can simply input them by typing.

How can I do this? Do I necessarily have to bind this table with any other in the DB?

 

[RuralGuy]

We are switching boats in mid stream. There are most certainly several ways to achieve your goal. You could probably do it with a Form and SubForm combination without opening another form. The MainForm would be bound to a query of your Clients and have a date field on the Form, and the SubForm would be bound to your charges query and use the ClientID and the date as the LinkChild/MasterFields. We'll take a long time resolving the issues if we keep changing plans.

 

[aian]

Sorry RG, you are right (well, again...). I'll stick to the previous version and try to resolve it. As you said, I need to get the Charges form working properly first.

The generic query to which you refered before should include what records? The client's records, the products records, the charges records or all combined? Can't figure that out(Looks like I need a rest, last night I slept for 5 hours and dreamt of tables and forms...).

 

[RuralGuy]

Is there any chance you can create a new db and import just the two forms and the three tables and then your macros? If so I may be able to read that and make some adjustments to your db. There is a lot of communication needed to answer some of the questions you are asking. Sorry, but I'm just trying to make this happen faster. I'm going to be gone now for a few hours. I'll check back in later. I've got to go clear about a foot of snow.

 

[aian]

Snow? I'm jealous, RG...

Anyway, I managed to do it, it works well, but don't ask me how...

Being disappointed as I was, I tried the other solution (you know, the "switching boats in mid stream") just for the fun of it. And it bloody worked! So I don't think I'll be a pain in the... head for you anymore (at least for that matter ;o))

I would like to thank you once again for all your devotion and effort to my problem. You really helped me a lot more than I would expect from any person/forum/acquaintance.

Thanks again, and if there's anything I can help you with, I'm here!

Alexander

 

[RuralGuy]

Excellent Alexander! That is really great news. There is so much more to learn if you can solve it yourself. Thanks for posting back with your success.