B
B
bbaggins2017-04-28 20:29:46
Microsoft Access
bbaggins, 2017-04-28 20:29:46

How to copy the value and pass it to the selection?

Friends, hello everyone!
Tell me, I'm making a small database in access, there are two tables 1 and 2, the second is subordinate to the first. It is necessary, by clicking on an element of table 2, to copy it to memory and transfer it to the selection of table 1. I am not very familiar with VBA, I tried to do standard macros, but recording through the expression builder of the form:
=[Аргументация]![Код] = [Ссылка].[DefaultValue]
Does not give an effect, in fact [Link] stores the very value that I need to substitute in [Argumentation]![Code].
It is necessary to click on the LINK line to move to the value of the Argument, here is the screen prntscr.com/f1ub8m
Here I posted the base - dropmefiles.com/Cs2zH
I will be glad for any tip.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artyom Karetnikov, 2017-05-02
@art_karetnikov

Well, everything needs to be redone. So far, the base is almost empty. Replace all these Russian tables and fields with English ones, give the correct prefixes, etc. And then see what a Linked field is

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question