Data Display in Access Form

[nileshhthakur2004]

HI all,

i have one DB in which i have one access table name Customer.
fileds of this table are CustomerID,CustomerName,CustomeAddress,CustomerCity
now i want to Display all Recods by four button First,Next,Last,Privous
so user can navigate all records Database is also in access and form is also in access can any one tell me how to do this ??

thanx in advance...

[RobDog888]

To start, set the recordsource property of your form to the table Customer. Then set the Record Selectors property to Yes. Then set the Navigation Buttons property to Yes. If you have any textboxes on your form set their Control Source property to the desired Field.

[nileshhthakur2004]

Hi RobDog,

thanx for your help but i am totaly new in Access, so i have no idea in which editor i need to write my program, and how to start it...

i have worked in VB and access so can you pls tell me how do i start ??

one more thing is i have no of controls on my form each control are for no of fileds in table customer like text box and all and i have four button on my form like first,last,privous,next to navigate how do i wok on it ??

thanx ..

[RobDog888]

This form is in Access correct? If it is then view your form in Design view and click the menu View > Properties. In this properties window you will see the properties I listed. Make sure the properties window is displaying the data for the Form object.

[nileshhthakur2004]

hi RobDog,
sorry i dont know your name that's why i use your username( RobDog ) only..
thanx for your help i have done all the steps as you tell me and it show me the Data from data base only one thing i have one label i want to display the data in this filed also as you told me from db how can i do this ??

do you know any best site which help as sample example and articale or forum for access ??

thanx onece again

[RobDog888]

I am working on finishing my FAQ for this site soon so stay tuned and we get allot of traffic here with allot of knowledgeable members.

You can not bind a label control to a control source via a property setting. Can you use a textbox control instead?

[nileshhthakur2004]

ok i will use the TextBox for Displaying CustomerID insted of using Label..
now i want to create one form which having ComboBox in it,which is bind with db table when user will select perticular records from ComboBox then Data related to it should be display in othere control's how can i do this ??

[RobDog888]

When you add a combo box control to yoru form a wizard should popup and give you three options. Select the bottom one that says - "Find record on my form based on the value I select in the combobox" and follow the steps in the wiz.

[nileshhthakur2004]

hay RobDog,
thanx for you answer and help.....

yes i got it now i have one form on which i have two button's "Delete" and "ADD" when i clieck on edit button one form will opening "frmAddDelForm" form contain two button on it one for Delete and other for Add if i navigate form "frmAddDelForm" through Delete then on form "frmAddDelForm" only Delete button should display and add button is get visible false ... same for Add button how can i do this ??
thanx in advance...

[RobDog888]

Create a Public boolean variable in a Module so you can set it to True to display a button and False if not from the first form. Then in the Form_Load of the second form you can check it and act accordingly.