how to Assign record to another record on different form (1 Viewer)

sspreyer

Registered User.
Local time
Today, 14:02
Joined
Nov 18, 2013
Messages
251
hi

all

right lets get started

I have form call frmmasksetup which holds records of the types of masks I have and this contains serial numbers from the masks ETC...

I have another form called frmemployee that hold all my employee's detail's name,last ETC

now my problem on the frmmasksetup page I have combo box to select employee but can't get it to Assign the mask to the employee

and on my employee form I have subform to display which mask is assigned to which employee



I have attach sample data base with speech bubble's showing what I try to do

hope I have gave enough info

any help much appreciated!!!!

thanks in advance

View attachment testforshane.accdb

shane
 
Last edited:

vbaInet

AWF VIP
Local time
Today, 21:02
Joined
Jan 22, 2010
Messages
26,374
What do you mean by you can't assign...? Does it throw an error message or it just doesn't get saved?
 

sspreyer

Registered User.
Local time
Today, 14:02
Joined
Nov 18, 2013
Messages
251
hi
no error message just does not assign (save)

thanks

shane
 

JHB

Have been here a while
Local time
Today, 22:02
Joined
Jun 17, 2012
Messages
7,732
Try it now, database attached.
 

Attachments

  • testforshane.accdb
    920 KB · Views: 148

JHB

Have been here a while
Local time
Today, 22:02
Joined
Jun 17, 2012
Messages
7,732
You're welcome, good luck!
 

Users who are viewing this thread

Top Bottom