Table update through form

marko

Registered User.
Local time
Today, 16:13
Joined
Dec 20, 2002
Messages
24
Hello everyone!

I'm stuck...

I have a form through which foreman makes a service request and that's stored in table tblexpenses.

Now, serviceman on his form types the dates for which he wants to see jobs "posted" by foreman. That works fine, dates populate combobox with corresponding data. Then (on the same form) he types up some more data (like what he did, which parts he used [ he picks parts from listbox which is populated based on combobox pick] and so on. And stores that in the same table.

What I also want for serviceman to do is check a checkbox stating that job is finished, because I want to use that checked box to discern which jobs are finished and which are not. Otherwise, when he enters dates, combobox will be populated always with same jobs that foreman requests (meaning all the old and new jobs). I want that checkbox so that only new jobs appear.

And now his omnipresent majesty... The Problem!

When I fill all that information on the form and press save record button, it is always saved as a new entry and what I want it to do is just to update what foreman requested with some new information (like that checkbox) because then I could make a query which would filter out every request that has checkbox stated "yes" (meaning job is finished). So if what foreman requested has ID 5 my form saves date under new ID (autonumber) insted under ID 5.

I guess that solution for this would mean that when I pick the job that foreman requested, my record navigator "jumps" to that ID instead of being locked to new entry. I thought the problem for this was because I put dataentry "yes" on my form . Puting that to "no" shows first entry on my form from the table. So when I make a choice from the combobox, I can see that data on the form is not changing depending on the choice so I guess I'm missing somekind of a link.

I would more than welcome any suggestions and comments!

Thank you!

Marko
 
Solved it! It took some tricks but it's working the way I wanted to! I used that old saying: "When you cant solve the problem, find another one!" :)))

Marko
 

Users who are viewing this thread

Back
Top Bottom