List box in form does not post data to table! (1 Viewer)

Angotedy · Aug 21, 2019

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 · Aug 21, 2019

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

Code:

[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.

Pat Hartman · Aug 22, 2019

I agree. Copying data from one table to another is probably the wrong solution. Why not explain your objective and we can help you to do what needs to be done.

Bound controls always save to the underlying table when they are updated. So, if your LitBox doesn't save any data, it is not bound. Just to clarify, multi-select listboxes cannot be bound.

Angotedy · Aug 23, 2019

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

List box in form does not post data to table! (1 Viewer)

Angotedy

New member

jdraw

Super Moderator

Pat Hartman

Super Moderator

Angotedy

New member

Similar threads

Users who are viewing this thread