Hi, i have an access (2002) form that pulls in allocation numbers & details for clothing allocations for new staff who will require safety clothing items for their job. when new employee posts are imported into the db they are checked to see if their posts require clothing. this works ok. however when the form opens to display a list of all employees who are to get clothong, along with the allocation number, & each item number & description, only the allocation number is displayed for all records - the item numbers only appear for the top record. if i click on each allocation number in turn the item numbers will be populated but i don't want to have to click on each row. i was using private sub formload, me.stockitem1 = me.allocationnumber.column3 ..... as me.allocationnumber refers back to the allocation table. I would be really grateful if anyone can help, thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
form only populating all fields for 1st record on form 1
- Thread starter mully1
- Start date
-
1
- #2
You can do a couple things...
Add the table and join it into the recordsource and then add the fields.
Copy the Allocationnumber control and change it's column widths so it displays the approriate column...
0";0";1"
Just make sure you leave it bound and make any appropriate control and label changes.
Add the table and join it into the recordsource and then add the fields.
Copy the Allocationnumber control and change it's column widths so it displays the approriate column...
0";0";1"
Just make sure you leave it bound and make any appropriate control and label changes.
- Status
Similar threads
- Locked
- Question
