List box in form does not post data to table!

[Angotedy]

Hi! Good Members, I am stuck and need your help, I have TWO Tables,
Table1 has: Pno, Name, Department for several individuals. This data needs to be retrieved on demand depending on the individual selected and to be posted to Table2 which has the following blank fields that need to be filled with information: Pno, Name, Department, Particulars, Date From, To. Please i will appreciate your help in making sure the List box posts data selected to Table2 along with additional fields

 

[jdraw]

I strongly doubt that this is a need if your database is properly structured.

[COLOR="SeaGreen"][I]This data needs to be retrieved on demand depending on the individual selected
 and to be posted to Table2 which has the following blank fields that need
 to be filled with information: Pno, Name, Department, Particulars, Date From, To.[/I][/COLOR]

Queries can be used to select data from different tables provided those tables are structured properly and relationship(s) between tables match your business rules.

Name is a reserved word in Access.
Access does not work well with field and/or object names that have embedded spaces.

Good luck with your project.

 

[Angotedy]

Thanks! i will be more than happy to share my intentions probably in the next 9hrs because I am briefly away.