[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Writing unbound colum to text field from list box

Posted on 2008-06-20
6
Medium Priority
?
209 Views
Last Modified: 2011-10-03
I have a form with  a list box with 3 columns
1 ID
2 bookid
3 title
The form control source is catalog
The list box control source is query from another table called library.
When user selects bookid (column2)
I want to write column 2 value to field book to table catalog.
I have my list box as 3 column count and bound column 2 .

Thanks
0
Comment
Question by:karen2662
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:Tirocupidus
ID: 21833123
I think you can just set the control source of your listbox to your "book" field.
0
 

Author Comment

by:karen2662
ID: 21833196
sorry I missed type the data is from a query the control source is the book field.
the problem is it writes from the id  column  instead of column 2. ( it writes the id instead of the bookid)
0
 
LVL 4

Expert Comment

by:Tirocupidus
ID: 21833867
Well, if you have the listbox control source set to your book field, and your bound column is the bookid column, it should work fine. I would just make sure you have your columns in the order you think they are, and you are binding to the correct column.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:karen2662
ID: 21834693
yes I have it set correctly but it still writes the ID value in the book field.
0
 
LVL 4

Expert Comment

by:Tirocupidus
ID: 21836118
Could you possibly attach the database or a sample of it so I can take a look?
0
 

Accepted Solution

by:
karen2662 earned 0 total points
ID: 21886833
I changed the design of the database.
Thanks for your help.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question