better control than default

[complexx]

I have a few forms in my database that I used the wizard to design. They work as intended however the default control that access uses is horrible. Is there a way to modify the control of these forms without building them from scratch? I'm afraid I wouldn't be able to build it from scratch and have it function as it does now.

 

[selenau837]

I have a few forms in my database that I used the wizard to design. They work as intended however the default control that access uses is horrible. Is there a way to modify the control of these forms without building them from scratch? I'm afraid I wouldn't be able to build it from scratch and have it function as it does now.

You can go into the VBA editor to modify the code that access built. You best bet would be to copy it and then modify the copy so you don't completely destroy what Access built.

What does it do and not do, and what do you WANT it to do?

 

[complexx]

What I'm trying to do is input data from the user.

The form looks something like the following:

---------------------------------------------------
___________________________________________

ADDRESS: XXXXXXX
SYSTEM: YYYYYYY
________________________________________
DATA:
ZZZZZZZZZZZZZZZZZZZZZZZZ
________________________________________
< < 1 > > >*
____________________________________________
< < 1 > > >*
--------------------------------------------------

The main form simply scrolls through all the ADDRESS and corresponding SYSTEM data. The Subform shows only the DATA input fields to enter data for that specific SYSTEM.

If I have 150 records of different ADDRESS it takes forever to find the right one. I'd like to use a combo box instead however when I change it over to a combo box in the design, it doesn't function properly. I know I'm probably missing a whole bunch of other modifications to get it work right.

 

[selenau837]

What I'm trying to do is input data from the user.

The form looks something like the following:

---------------------------------------------------
___________________________________________

ADDRESS: XXXXXXX
SYSTEM: YYYYYYY
________________________________________
DATA:
ZZZZZZZZZZZZZZZZZZZZZZZZ
________________________________________
< < 1 > > >*
____________________________________________
< < 1 > > >*
--------------------------------------------------

The main form simply scrolls through all the ADDRESS and corresponding SYSTEM data. The Subform shows only the DATA input fields to enter data for that specific SYSTEM.

If I have 150 records of different ADDRESS it takes forever to find the right one. I'd like to use a combo box instead however when I change it over to a combo box in the design, it doesn't function properly. I know I'm probably missing a whole bunch of other modifications to get it work right.

Can you please upload an example of what you got so I can look at it and try and help ya.

 

[complexx]

Ok, try out the attachment.

the form I'm working with is called "Add Service Visit"

Its simply used to add the data from a service visit to a specific location for a specific system present at that location.

 

[selenau837]

Ok, try out the attachment.

the form I'm working with is called "Add Service Visit"

Its simply used to add the data from a service visit to a specific location for a specific system present at that location.

There you go, I have the combo box working for you now. You will be able to see the changes I made. However you there is alot more you will need to do. Currently that form isnt' set up to all data entry.

About to head out, but I hope this is a start for ya.

 

[complexx]

Thanks for the help. Thats about as far as I was getting before. My problem is that I don't how to make the combo boxes replace the function of those two Record traversal tools at the bottom of the form.