Search results

  1. M

    What type of control to display data?

    I think we're off the tracks, Gina. I made a few changes to make this clearer. Here are my tables and fields: ManagementCompanies_table: ManagementCompany (primary key) PhoneNumber Complex_table: complex_abbr (primary key) complex address_line1 managmentcompany (linked to...
  2. M

    What type of control to display data?

    The bound column is complex. Would it be a better method if I built relationships and created a query?
  3. M

    What type of control to display data?

    managecoview is a textbox with controlsource =Complex.column(2) There are 6 fields that get populated from the combobox I'll have to think about this. I really need the combobox to be used for the complex. I guess the question is will the dlookup work when you the value you need is in a...
  4. M

    What type of control to display data?

    I must not be using it incorrerctly, here's what I used: =DLookup("phonenumber", "managementCompanies_table", "[managementcompany]='" & Me![managecoview] & "'") managecoview is a text box on the jobs form that displays a column from the query that fills the combo box for complex...
  5. M

    Should Abortion be Allowed?

    If moral absolutes exist they must come from God, otherwise they are simply personal preferences. If a society agrees on a set of morals they're still just personal preferences on a larger scale. And I doubt societal morals are ever actually upheld. Are there really no homosexuals in Iran...
  6. M

    Should Abortion be Allowed?

    The question behind question is 'does God exist'? If God does not exist then moral absolutes do not exist. This point cannot be debated. Abortion is no better or worse then removing lint from your belly button. If God does exist then one must find out what God says about abortion.
  7. M

    What type of control to display data?

    I have these tables: jobs, complex, managementCompany, managers. I built a form for each table. In the form for jobs I have a combo box for the complex field that's based on a query to bring in the complex, manager, managementCompany and address. I created text boxes for manager...
  8. M

    Form design question

    Thanks. So the employees and hours would be a subform to the status subform?
  9. M

    Form design question

    I want to build a form for a 'job' that contains a daily status, the employees who worked on the job and their hours. I know that the daily status part should be a sub form but how should I include the employees and their hours? Thanks.
  10. M

    strange form behavior

    Thanks, that works exactly how I want it to.
  11. M

    strange form behavior

    I built 2 tables: Complex_table and ManagmentCompanies_table. Complex_table has these fields: complex, ManagementCompany and ManagementPhoneNumber. ManagmentCompanies_table has these fields: ManagementCompany and PhoneNumber. There are several rows in Complex_table that have a value for...
Back
Top Bottom