Setting a value in another form

[ick64]

Hello all,



I can use DLOOKUP to retrieve a value from a table and use it in a field in the current form.

But how can I take a value from my current form and use it in another form?

This is what I need: Form1 is open and whenever I input a value in a specific field, there is an "after update" sub to take this value to a field in Form2.

How can I do it?


Thank you!

[ranman256]

just use the full path:

forms!myForm1!txtbox1 = forms!myForm2!txtbox2

[ick64]

Thank you ranman256 but I have realized my question was not complete.

Actually, with the value taken from a field in the current form, I need to access another table and set that value to one of its fields. Simply putting, it would be the reverse of DLOOKUP...

Any tip?


Thanks again!

[June7]

The original question was complete enough but now your question is completely different.

Why duplicating data between tables?

Would have to run an SQL UPDATE action to directly populate field in table.

But if you have 2 forms open why not use ranman's suggestion?

[ick64]

Thank you June.

The valid question is really the 2nd one then. Actually I am duplicating data because I do not know how to run SQL UPDATE etc. - I am a newbie in Access...


Thanks again!

[June7]

Still doesn't explain why you need to duplicate the value in two tables. Has nothing to do with HOW it is entered into the second table. Why is it there at all?

Really need more info about what this db is for and its structure.

[ick64]

For short, one table (let´s say Table1) - and its form - is about internal request of quotes (RFQ). The other table (let´s say Table2) - and its form - is about the quote for the customer.

I read some fields from Table1 to start populating data at Form2 (table2), and then, whenever the quote is accepted and I fill in the acceptance date, I want this info to populate a date field in Form1 (Table1).

Later on I want to be able to run reports either from Table1 and Table2, checking which request of quotes turned into deals, which quotes turned into deals and when, etc.


Thank you!

[June7]

Do the tables have a relationship? Is a primary key from Table1 saved as foreign key in Table2?

[ick64]

No, they are not related...

Thank you!

[aytee111]

Separate these forms into two unrelated forms.
- form 1, add a new quote (or look up an existing one), show all the data from table1
- form 2, select a record from table1 to add a new quote, or select a record from table2 to display an existing one

When you add a new quote for form 2,
- provide a combobox of all records from table1 with no accepted date
- user selects one from this list
- run an append query, append the fields to table2 (only the fields that are missing from table1, these two tables should be linked so that no duplication of data is necessary)
- now you have a quote record in table2 where you can begin updating the data
- in the AfterUpdate of form 2, run an update query to add the accept date to the table1 record

[ick64]

Great _ I will do it, thanks a lot!