Best way to create a list of items

I hope I can explain this one well.  I am trying to figure out how to best create a list of items for a user to use on a form.  Please see the example screen shot to se what I need.

The list needs to be displayed on a form and the user needs to be able to enter the Prices per the example.

There are two quirks...

1) The list needs to be sorted in an order as defined by the user.
2) The user needs to be able to add an item to the list when needed.
3) The list will need to display all items even if the Price is "$0.00"
4) The user needs to be able to enter the price data for each item.

Has anyone ever created anything like this?  What is the best way to handle this?

I'm looking for advice and any help will be much appreciated.

--Steve
ListExample.jpg
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
In a form you won't be able to do the offsetting of text as you have shown unless you get into a more complex design involving subforms.  Edit... sorry - no -even then it would not look like your example.

For the user to control the item sequence they must set the value of a field that would be used to sort the items.

See the attached example...
Database1.mdb
0
 
SteveL13Author Commented:
I like what you've suggested.  but please see my database attached.  I can't figure out why all the records aren't showing up on frmBudget.
Database2.mdb
0
 
peter57rCommented:
They are for me.  There are 12 records in your table and they all appear on the form.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
SteveL13Author Commented:
Strange. I only see 7.  ????
0
 
peter57rCommented:
this is what I get
Capture11.PNG
0
 
SteveL13Author Commented:
Here's what I get.  What in the world is going on with this?
What-I-Get.jpg
0
 
peter57rCommented:
I don't know why that is.
Try making the design view of your form bigger and saving it again.
0
 
SteveL13Author Commented:
This is strange.  I had a horizontal rule at the bottom of the header and another one at the top of the footer.  When I removed them both it worked.  Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.