A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to change the order on a form?



 
 
Thread Tools Display Modes
  #1  
Old November 4th, 2004, 12:07 AM
Wandakv
external usenet poster
 
Posts: n/a
Default How to change the order on a form?

I rearranged my table and can't get the form fill-in to go in the same order
as the table?
  #2  
Old November 4th, 2004, 12:20 AM
fredg
external usenet poster
 
Posts: n/a
Default

On Wed, 3 Nov 2004 16:07:03 -0800, Wandakv wrote:

I rearranged my table and can't get the form fill-in to go in the same order
as the table?


If you are talking about the sort order of records displayed in a
form, create a query using all the fields you need in the form. Sort
the query as to how you want it, then use the query as the Form's
record source.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
  #3  
Old November 4th, 2004, 12:28 AM
Line Riendeau
external usenet poster
 
Posts: n/a
Default

Hi,

A right click on the form, and choose "automatic selection".
"Wandakv" a écrit dans le message de
news: ...
I rearranged my table and can't get the form fill-in to go in the same
order
as the table?



  #4  
Old November 4th, 2004, 12:45 AM
Fred Boer
external usenet poster
 
Posts: n/a
Default

Dear Wandakv:

Fredg has suggested the proper approach to solve your problem if the problem
is the order in which records are displayed. However, I wonder if you might
be talking about the "tab order" of the form; that is to say, the order in
which you go through the boxes on the form as you press "Tab". If so, you
can adjust the "Tab Order". Post back if this is what you are looking for.
If not... never mind! g

HTH
Fred Boer

"Wandakv" wrote in message
...
I rearranged my table and can't get the form fill-in to go in the same

order
as the table?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Order of 3-part Form KG General Discussion 1 October 28th, 2004 06:41 PM
Adding a Record to a Form Out of Order Lisa Using Forms 3 September 29th, 2004 04:46 PM
customizing the tab order in a form in Word Shannon General Discussion 1 September 16th, 2004 07:14 PM
Text form fields Jerry General Discussion 5 August 24th, 2004 10:43 PM
Problem adding a command button to a form in order to open another form Janice New Users 2 May 10th, 2004 11:31 PM


All times are GMT +1. The time now is 04:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.