movin a record up or down in a table

[hunterfan48]

can you do that? if so how? I'm entering all my sports card into a table called 'card inventory.' As I'm putting the cards in, I put them in numerically according to each new set I put in my card inventory table. However, If I were to buy some more cards to a certain set, how could I specifically add a new record and move it between the 2 records where it's card number fits...for example 33 would go between the record with card number 32 and record with card number 34?

plz help!
thanks!

 

[pbaldy]

You can't really control where the record physically resides in the table, and you don't really want to. You would just order the records correctly when you present the data in a form or report. In other words, you would order by card number in a query/form/report, and 33 will appear between 32 and 34, irregardless of what order they are in the table.

 

[hunterfan48]

ok thanks so much! btw...I created a form that way I can either enter my data in the table or the form. However, sometimes when I switch from one to the other, it no longer displays the information in some my 'lookup wizard columns?' any reason why???

 

[hunterfan48]

o I know what it was, I was using a form to enter data into my table. But, I decided to add another column to my table for information purposes and I couldn't get that new column to show on the form. Is there a way i can do that? I didn't know how so I deleted it and created a new form.

 

[pbaldy]

You should have been able to put the form in design view and add a new textbox (or whatever), putting the new field in its control source. By the way, most of us don't like table level lookups:

http://www.mvps.org/access/lookupfields.htm

 

[amerifax]

>>most of us don't like table level lookups:<<

Sorry for jumping in BUT.

By table level do you mean Right Click on field name and using "Find"? If so why?

Bob

 

[pbaldy]

No; with a table in design view, there's a Lookup tab in the bottom section. That's the feature most us don't like.