473,394 Members | 1,642 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How do I create a search box on two fields to populate a form?

I have a Master table with two fields that make a record unique: PolicyNumber & PolicyYear.

I need to create a search box based on these two fields to populate a form. A Policy Number may have multiple Years, so I need both fields in order to get the correct record to update. I tried an Embedded Macro & VBA script unsuccessful. I don't care how I do this. Please help.

Disperate!
Apr 26 '13 #1

✓ answered by NeoPa

You can use a pair of ComboBoxes to filter the records. If you use Cascaded Form Filtering this will do the whole job for you neatly.

1 1067
NeoPa
32,556 Expert Mod 16PB
You can use a pair of ComboBoxes to filter the records. If you use Cascaded Form Filtering this will do the whole job for you neatly.
Apr 26 '13 #2

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

Similar topics

1
by: SamBenjamin | last post by:
Is it possible to incorporate a search into a form using a text field for the search word(s) and a command button to start the search, returning results that don't exactly match.. For example...
1
by: JohnM | last post by:
It seems a little odd to think about adding fields to a table, but I'm trying to put something together to help me with my marking ... a teacher! A table represents a mark sheet and i want to add...
1
by: Joey Mok | last post by:
Hi, How to create a Sales Order form with ASP.NET 2.0? I want to save the sales order header and its items at the same time. Can I make this web form with ASP.NET 2.0 new Data Controls? ...
1
by: jaishu | last post by:
Hi, I have a form with a subform, Both of them are based on a query.the form displays a productid and its details ,and the subform has matching productnames for that productid. Now i have a...
2
by: chobo | last post by:
I'm not sure where to post this question, so sorry if it's in the wrong place. I have a design related question relating to xml files stored in a mysql database. I was wondering how some of you guys...
21
by: bha123 | last post by:
Hi I am struck with this problem . i have 2 forms .. Form A has 2 dropdown box state : city :
7
by: linsha | last post by:
Hi... I want to whether there is any possibility in creating 400 text boxes and labels inorder to create 400 fields in SQL. If created using control array then which is the way to see the text boxes...
4
by: cmbirk | last post by:
Hi everyone, I am trying to create an access database for reporting in my division, and I need to be able to create new fields in a form as they get used. For example, if someone fills in a...
2
by: dragmn2 | last post by:
Hi, I am new to Access and I seem to have run into a conundrum. I am currently using Ms Access 2007. I have a table setup with 12 fields and form with 12 fields which is corresponding to the 12...
1
by: dhivyacse | last post by:
i! how to create search engine inside the website only without using database
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.