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

[leegun]

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)

[NeoPa]

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.

[leegun]

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?

[NeoPa]

Why would you want something other than a Form when a Form can do it quite straightforward ly?

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.