By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,273 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,273 IT Pros & Developers. It's quick & easy.

Creating a form with a search number, display data and combo boxes that add to db

P: 2
I am looking to create a form, (maybe switchboard) whatever works that connects to the table of data

The table contains name, dob, age, address, ID number, postal address, city, plus I need 2x combo boxes to add more data.

I need the form to be searchable for the ID and pull up all the other information and display it without it be changeable to the record/table.connect.

Once I search the ID and it display age/dob etc I need 2x combo boxes that will have 3 or 4 items to choose from and that when selected update the table.

I understand basic forms. I get basic swithboard, but how do I have 1-searchable item, then that displays basic info and from that I can add info to the table/record with a combo (drop down box)?

So it would look like:

ID number (searchable but doesn't change table)
name (just displays)
address (just displays)
dob (just displays)
postal address (just displays)
city (just displays)
combo box 1 (choose from 4 things and it adds it to table)
combo box 2 (choose from 4 things and it adds it to table)
2 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,660
Hi Lee.

Welcome to Bytes.com.

I'm struggling to understand your requirements here.
LeeGun:
I need the form to be searchable for the ID and pull up all the other information and display it without it be changeable to the record/table.connect.
...
I understand basic forms. I get basic swithboard, but how do I have 1-searchable item, then that displays basic info and from that I can add info to the table/record with a combo (drop down box)?
I can't see how a Form can be both read only and allow you to add data at the same time.

Also, this seems like a fairly basic Form filtering scenario (See Cascaded Form Filtering). It may be that you need to set the dataset to read-only depending on what your actual requirements are, but I don't see any other complications here, based on what you've said.
2 Weeks Ago #2

P: 2
The idea is that we can search for a customer with an ID number, some basic info then pops up like name and address so we can confirm that is the correct person, then add some basic info with a combo box that gets added to the Table.
All this on the one thing.

Would something other than a Form do this?
2 Weeks Ago #3

NeoPa
Expert Mod 15k+
P: 31,660
Why would you want something other than a Form when a Form can do it quite straightforwardly?

There are many ways to stop updates on a Form, even if the record is fundamentally updatable. You could even make it follow a process flow so it's only updatable once you've confirmed you want to.

If you have specific questions about how you'd go about this then I'm going to need a clearer explanation of what you're trying to achieve. From what you've said so far though, it all seems doable.
2 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.