i want to add data from pop up form

[newegyptian]

I have customer table contain ID , NAME , AGE






I have phone table contain ID , TYPE , NUMBER



I made one to many relation between two table ID , ID



I made customer form


I made phone form pop up type


I made button in customer form to open phone form specific to customer form



but when I open button , it didn't set ID as default so I cant add numbers to the specified customer



how I can solve it

[June7]

Recommend using form/subform arrangement. Otherwise, need tricky code passing data between forms and there is more than one way to do it.

[ssanfu]

Also be aware that "name", "Type" and "number" are reserved words and shouldn't be used for object names.



Please stick with one thread until your problem is solved. Otherwise people will get tired of trying to follow multiple threads and ignore your questions..... just saying..........



BTW, welcome to the forum......

[phivosz]

Add this to the On Open event of phoneform: Me.ID=Forms!customerform!ID That should do it

[June7]

If the form opens to existing record, that code will replace value. As I said, gets tricky to pass data between forms. A form/subform arrangement handles this for you.

[newegyptian]

how i can use these ways

[newegyptian]

Also be aware that "name", "Type" and "number" are reserved words and shouldn't be used for object names.



Please stick with one thread until your problem is solved. Otherwise people will get tired of trying to follow multiple threads and ignore your questions..... just saying..........



BTW, welcome to the forum......

thanks

happy to be in this form

[newegyptian]

Add this to the On Open event of phoneform: Me.ID=Forms!customerform!ID That should do it

please write all code which i should write in it


Private Sub Command17_Click()
End Sub


i am new to access

[June7]

Okay, if you really want to go down this path, try:

If Me.NewRecord Then Me.ID=Forms!customerform!ID

[newegyptian]

Okay, if you really want to go down this path, try:

If Me.NewRecord Then Me.ID=Forms!customerform!ID

i made this but not work

[newegyptian]

also this not work

[Micron]

Looks to me like you put it in the wrong form. You're showing a button click event, which is on the first form, yes? You're setting the id value to be what it already is on that form IF the statement would evaluate to TRUE which it won't because it's not a new record on the first form.
Move the code to the opening form as was stated in post 4. If I'm wrong about where the code is, my apologies.

[newegyptian]

Looks to me like you put it in the wrong form. You're showing a button click event, which is on the first form, yes? You're setting the id value to be what it already is on that form IF the statement would evaluate to TRUE which it won't because it's not a new record on the first form.
Move the code to the opening form as was stated in post 4. If I'm wrong about where the code is, my apologies.

i made that .. did i miss thing ??

[June7]

I tested Open event and it would not work. Use Load or Current event.

But if ID is an autonumber field in this table, cannot set its value. Is ID a number type field that is for the customer ID foreign key? Should give fields better names. Avoid using exactly the same name in multiple tables.

[Micron]

According to 2nd and 3rd images it is not autonumber.