Hi everyone
I have a table with 14 column fields and on a separate form has a list box with the record source set to this table and text boxes bound to the first 11 columns, so when the user selects a row in the list box, the text boxes autopopulate with their respective column info. However my new task to add 2 more important column fields. The goal is for the list box to display 5 of the total 13 columns, but the textboxes to include the rest of the columns. Essentially the user sees the information in the 5 columns and the text boxes include additional information. Before I play around with this as I've had some issues with Access crashing on me lately, does anyone have any advice or information on how I can display a few specific columns from a table onto a listbox, but have the textboxes display the rest? Thank you!
I have a table with 14 column fields and on a separate form has a list box with the record source set to this table and text boxes bound to the first 11 columns, so when the user selects a row in the list box, the text boxes autopopulate with their respective column info. However my new task to add 2 more important column fields. The goal is for the list box to display 5 of the total 13 columns, but the textboxes to include the rest of the columns. Essentially the user sees the information in the 5 columns and the text boxes include additional information. Before I play around with this as I've had some issues with Access crashing on me lately, does anyone have any advice or information on how I can display a few specific columns from a table onto a listbox, but have the textboxes display the rest? Thank you!