Results 1 to 3 of 3
  1. #1
    Dualxeon is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2020
    Posts
    8

    Not Sure what I need I want a field I can enter a number in for example Number Ordered

    Okay very new and learning. Got a simple database going with items that I will need to order from time to time. I have created a OrderForm that when I chose item number from cboBox it auto fills in the rest of the fields and drops down to next row/item number to order second item. My problem is I need to have some way to add a field to enter in a number like I want to order 10. I tried a text box, but whatever I put in the first item (example 10) when I drop to second row to order something different it already has 10 in it. I hope this makes sense.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    you must bind the form to a table: tOrderItems
    the box is bound to field: QTY
    fields:
    ItemNum
    ItemDescr
    Qty
    Price

    unbound fields will be the same on every record.

  3. #3
    Travis is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2020
    Posts
    15
    Ranman256: This is not my question but I am very much a newbie as well. Your comment: "unbound fields will be the same on every record." produced a light bulb above my head...I now understand a couple of things a little betterer than I did a few minutes ago. Thank you!
    Last edited by Travis; 12-08-2020 at 11:24 PM. Reason: Correct mis-spelling

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 11-01-2017, 11:25 AM
  2. enter number for month
    By slimjen in forum Queries
    Replies: 2
    Last Post: 01-07-2016, 11:25 AM
  3. Replies: 2
    Last Post: 06-01-2013, 07:00 AM
  4. Replies: 6
    Last Post: 01-24-2013, 10:02 PM
  5. Yes/No, If yes Enter Number
    By kennyrogersjr in forum Forms
    Replies: 1
    Last Post: 11-29-2010, 07:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums